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
Dig deeper on Microsoft SQL Server Performance Monitoring and Tuning
Related Q&A from Jeremy Kadlec, Contributor
Adding non-clustered indexes to SQL Server columns and tables frequently queried is possible. Learn how to add non-clustered indexes to SQL Server ...continue reading
Learn how to view a query execution plan in SQL Server with SQL Server Management Studio or Query Analyzer. Review and decrease query plan sub tree ...continue reading
Want to change the collation to SQL Server 2005 standards after upgrading databases from SQL Server 2000? Learn the best approach involving DTS and ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.