Why this query takes loger to execute

wherrera 2013-06-11 19:43:52

SQLkiwi 2013-06-16 03:43:37
The submitted plan only shows estimated numbers. We could give a fuller answer from an analysis file captured after execution.
Thomas Stringer 2013-06-12 12:47:14
Right off the bat one of the more costly operations in that plan is a key lookup on Table3. Because Index7 isn't a covering index, SQL Server needs to do a Key Lookup to grab Column7 and do a nested loop join on it.

My first step would be to ensure Table3.Index7 is a covering index.

alt text