Optimization Help

jplugge 2014-10-27 20:36:31

sqldriver 2014-10-27 20:57:33
All I can see is adding indexes to support the two sort operations, and perhaps adding the column in the key lookup as an include, since there's just one.

If you can send an un-anonmymized plan, we might be able to offer more.

jplugge 2014-10-27 20:59:58
Thanks for the prompt answer, I figured it out, I need to add one column into the index as an INCLUDE. It will help the sort and remove the BML.
nhmidi 2014-10-28 07:34:57
http://blog.sqlauthority.com/2009/11/09/sql-server-removing-key-lookup-seek-predicate-predicate-an-interesting-observation-related-to-datatypes/