SELECT * FROM XYZ WHERE del_date BETWEEN @datefrom AND @dateto AND orderid=@orderid AND seqno=@seqno
ORDER BY orderid, seqno,del_date
Now, after implementing the index, the query still responds very slowly. What other steps are needed to resolve the problem?
- Evaluate building a clustered index with the same column definition
- Evaluate building a clustered index based on an identity and separate non-clustered indexes for each column
- Evaluate building three separate non-clustered indexes for each of the columns
This was first published in December 2005