I have this SQL query which runs against multiple databases. There were originally no indexes and I created some, after creating them it is doing Index seek but that is not helping very much. Original run time was 3:05 minutes now it runs in about 2:35. Please take a look at the plan and point out any areas that need attention.
By sqlzees 1 asked Jan 12, 2016 at 09:28 PM