How can I reduce the number of clustered index scans?

AmitL 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.