Multiple choice technology databases

Microsoft recommends a clustered index in every SQL Server table

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Microsoft recommends a clustered index for almost every SQL Server table because it physically orders the data, greatly improving retrieval speeds for range queries and joins. Without a clustered index, the table exists as an unordered heap, which can lead to severe data fragmentation and slower lookups.