SQL query performance killers – understanding poor ...
SQL query execution on a table with millions of records without a clustered index requires a lot of time. Also, if you need to get a sorted results list, it's easier to define an ascending or descending clustered index, as shown in the examples above, than to sort the unsorted results set retrieved from a …