August 3, 2009 at 9:38 am
Hi All,
Quick question; Does the update statistics at the end of the rebuild indexes job cause all query plans to be re-compiled?
Thanks
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
August 3, 2009 at 9:56 am
I don't believe so.
August 3, 2009 at 1:18 pm
Didn't you just ask this question under a different topic?
Please don't do that. It makes conversations harder to track.
Actually Steve, if I'm understanding the question, I think the answer is yes. If the OP is asking if statistics get updated during an index rebuild, which, they do, they get rebuilt themselves from a full scan of the key values of the index, then yeah, the procedures get marked for recompile.
Maybe I'm misunderstanding the question though.
"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
August 3, 2009 at 1:21 pm
Do all procedures get marker or only those from the dependency tree in SQL Server get marked? I assume this is at the end of each index that is rebuilt?
August 3, 2009 at 1:24 pm
Sorry, only the ones that are associated with the index that was rebuilt.
"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
August 4, 2009 at 2:45 am
Many thanks for the prompt response and apologies about the duplication of the post (I realised that this forum track was a better place to post it)
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply