Sean Lange (10/9/2015)
It will generate an execution plan for this view if one is not already cached when a select statement is executed. If the execution plan already exists in cache it will reuse it.
Nope. Views don't have cached execution plans.
The query which referenced the view will have an execution plan, one which includes no mention of the view, as the view is unrolled during parsing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability