HiveBrain v1.2.0
Get Started
← Back to all entries
gotchaMinor

difference between index REBUILD and REORGANIZE in relation to recompile in SQL Server 2008 R2

Submitted by: @import:stackexchange-dba··
0
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.