Sample Header Ad - 728x90

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