| TABLE 1: Average Sort Execution Times |
| Index Created | Average 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 |