How can a key lookup with zero executions and zero actual rows take time?
4
votes
1
answer
276
views
I have a query that is taking about 10 seconds to run and I am trying to optimize it.
All the time is spent in the key lookup which is fine however in this case if I mouse over the key lookup in the actual execution plan it says
Expected Rows : 1
Estimated Executions : 3341
Actual Rows : 0
Executions : 0
I understand in this case the statistics are expecting the index seek to find rows which is fine but as no rows were returned in the Index Seek why would the key lookup take any time? or even be shown in the query plan at all?
Asked by Gavin
(556 rep)
Sep 7, 2011, 04:39 PM
Last activity: Aug 12, 2017, 08:02 PM
Last activity: Aug 12, 2017, 08:02 PM