TABLE 1: Average Sort Execution Times
Index CreatedAverage Execution Time (in seconds)
Nonclustered index on customerid 150
Two nonclustered indexes (on customerid and orderdate) 145
Composite nonclustered index on customerid and orderdate 120
Covering index 60
Composite clustered index on customerid and orderdate 15