Index on (IsDeleted, SubmitDate DESC) include (ProdName,Category,TotalStock,Price)
btw, that's a rather odd predicate on the date column...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability