gotchaMinor
difference between index REBUILD and REORGANIZE in relation to recompile in SQL Server 2008 R2
Viewed 0 times
2008recompilesqlserverrebuilddifferencebetweenandindexrelation
Problem
Does the INDEX REORGANIZE index cause recompilation of the stored procs the same way as INDEX REBUILD
Solution
Index reorganize does not touches statistics so there is no chance for causing recompilation. Since when index is rebuilt with full scan stats are also updated for the column this can trigger recompilation as statistics change.
Context
StackExchange Database Administrators Q#72238, answer score: 2
Revisions (0)
No revisions yet.