June 8, 2007 at 9:26 am
I don't have AdventureWorks installed so I can't try it myself right now, but - does that result in different plans because the data is different? And if so, doesn't that invalidate your results assuming that you want to show that the estimated plan cannot necessarily be trusted?
June 8, 2007 at 9:38 am
The estimated plan can't be trusted because statistics & data can get out of sync. I had to come up with a contrived situation to display it. Silly, I'll grant you, but illustrative, which is all it was meant to be. Unless someone has a better idea? I'm game for more.
"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 - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply