This needs to use less CPU

SQLJeet 2016-02-03 19:43:20

Can someone help me speed this query up? I dont even know where to start on it.

NEERAJ PRASAD SHARMA 2016-02-11 07:04:16
How much time query is taking to complete?
Aaron Bertrand 2016-02-19 20:33:51
I'm not sure I follow – this plan seems to use very little CPU at all, and all three statements ran in under 140 milliseconds. Could you expand on this and explain what needs to be optimized? Is this query only a problem with a different data set not captured here, or when many more concurrent users are running it?