July 15, 2010 at 5:32 am
We have an application (developed for us) which relies heavily on nested views. So if the "main" (lets call it A) view looks at another view (B) where if B is opened it does a full table scan, does that mean when A is ran with a criteria it needs to let B do a full table scan first and produce all the results to hand to A ?
If the view has indexes does that make it any different ?
July 15, 2010 at 6:36 am
Please don't post in duplicate locations. It just diffuses the conversation.
All replies to this thread please.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply