tony28 (10/31/2013)
slower queries are important but i think the CPU time = 78 ms, elapsed time = 79 ms are ok no??or do you think that is it problem ?
If the times are OK, why are you optimising the query in the first place?
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