Hi there, In one of my stored procedure there is a simple query which is taking around 30 seconds to run. The table have 6592978 records in it. And there are 2 indeces on the table on Clustered index on the Identity Column of the table and other on the FormID. Identity column is other than CustID column. SELECT TOP 1 dtmDateAdded FROM tblXXX WITH(NOLOCK) WHERE CustID = 123 AND FormID = 123 ORDER BY dtmDateAdded DESC Please advice. Thanks!