QUESTION POSED ON: 26 December 2005
Here's the situation: A composite nonclustered index is created with XYZ table with the columns ordered, seqno,del_date to improve the query below:
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?
|
