Am I missing anything obvious while tuning this query ?
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.