Press "Enter" to skip to content

Using SORT_IN_TEMPDB on Index Rebuilds

Jack Vamvas covers the SORT_IN_TEMPDB flag for index operations:

Question:There is a SORT_IN_TEMPDB option for SQL Server index create and rebuilds . Is it possible to exploit this option to improve the SQL Server index rebuild performance?

There can be some reasons to do this, particularly if tempdb is on much faster storage than your database files, but read the whole thing for caveats.