How can I reduce the number of clustered index scans?
2013-12-19 15:54:23
Hey
This query is a group by cube() query. the results are inserted into a temporary table for further analysis. As you can see below there a lot of index scans on the base table (Table2.index1)
Any thought would be very much appriciated.
Aaron Bertrand 2013-12-19 15:57:54
Hi Amit, it's really hard to offer suggestions against an anonymized query plan. Any chance you can post a non-anonymized version, or send one to me directly at abertrand@sqlsentry.net? Thanks.