Chapter 15: Maintenance Activities and Performance
Speeding
index creation with sorted_data
If data is already sorted, you can use the sorted_data option
for the create index commandto
save index creation time. You can use this option for both clustered
and nonclustered indexes.