Home Forums SQL Server 2012 SQL Server 2012 - T-SQL How to optimize this query RE: How to optimize this query
Eirikur Eiriksson
SSC Guru
Points: 182882
More actions
April 1, 2015 at 7:21 am
#1788005
Quick suggestion, add a clustered index to those heaps and look into indexing them, the table scans are more than 80% of the cost.
😎