Interview Questions
1. What is SORT_IN_TEMPDB option while creating or rebuilding an Index?
When we create or rebuild an index, by setting the SORT_IN_TEMPDB option to ON we can direct the SQL Server Database
Engine to use tempdb to store the intermediate sort results that are used to build the index. Although this option increases the
amount of temporary disk space that is used to create an index, the option could reduce the time that is required to create or
rebuild an index when tempdb is on a set of disks different from that of the user database.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment