Can you suggest what can be done to improce my query

Arun 2014-07-30 01:13:46

Edward Norris 2014-07-30 11:56:00
You are getting index seeks except for the one index scan at 27%. That is such a small table, it may always give you a scan…you can add columns 2,7,9, and 11 to table1.index1 as "includes" and it would remove the Key Lookup.