Query / Index Tuning Guidance

Brandon Richards 2017-03-15 17:04:24

Hi,

I don't have much experience with query tuning, so I'm hoping you all can provide me with some guidance on this. Please let me know if I can provide any specific information to help in the analysis.

Thanks!

Vlady Oselsky 2017-03-23 19:32:36
I would try to reduce the size of the query sooner instead of waiting until HAVING clause. Currently, you have amount 5,000,000 rows through most of your plan until it reduced to 11 rows. If you can reduce it sooner you will not have TempDB spills and some of your INDEX SCANs could be INDEX Seeks.