How can I reduce the number of clustered index scans?
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.