I heard from a Developer that when we create a regular View, SQL server will cache it's execution plan. And that using a regular View is actually a performance enhancement for this reason.
Does anyone agree with that or has observed anything of that nature?
My understanding is that regular views are neither positive nor negative in terms of performance. SQL Server will evaluate every query that uses a view on it's own merit. In addition, I've tried clearing the cache and creating a view and I don't see anything in the cache, until I create the query. Then again I haven't used SQL Server 2019 too much so maybe things are different there.