How to optimise T-SQL query using Execution Plan
I have done a fair amount of T-SQL, but using execution plans to optimise my query is a new area for me and I have really tried to understand how to do it. So, if anyone could help me with this and explain how this execution plan can be deciphered to find ways in the query to optimise it, I would be eternally grateful. I have many more queries to optimise – I just need a springboard to help me with this first one.
I believe that there are plenty of possibilities here. I'm sure others will point out a lot of them, but the very first thing I notice upon opening this is how far off the estimates are from the actuals.
If this were my query, I would start there.
I hope this helps!