April 4, 2011 at 1:53 pm
If I were to restore a DB from production to any other server, would the execution plans and statistics come with the prod backup?
There is an exception to every rule, except this one...
April 5, 2011 at 5:25 am
SQLHeap (4/4/2011)
If I were to restore a DB from production to any other server, would the execution plans and statistics come with the prod backup?
Yes, on the statistics, no, on the execution plans.
Statistics are stored within the database. Execution plans are stored in memory in the procedure cache, so they're not part of any database backup.
"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
April 5, 2011 at 7:14 am
Thanks, that's what I thought. I appreciate the response.
There is an exception to every rule, except this one...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply