I am new to using your SQL Sentry Plan Explorer.
I have a hash Match (Aggregate) with a 45.7% cost and a Table Insert with as 52% cost. The SQL uses a clusted index scan and 2 hash matches. One hash match on the join and one for the aggregate. The SQL is below.
I wanted to try using Trace Flag 610 to help with the inset into (#temptable) to minimal log the insert to increase performance. Will that work?
Also, what can I do with the 2 Hash Matches?
Do I need additional indexing?
Can I check indexing with SQL Sentry Explorer?
By rpcasey001 0 asked Dec 13, 2016 at 07:49 PM