More cubes
Cubes are populated on initial load, and re-computed using ALTER CUBE REBUILD
Optimizer replaces aggregations with a query on a group table:
- SELECT partid, count(*) FROM sales GROUP BY partid HAVING avg(price) < 5.00 becomes
- SELECT partid, count_star FROM salesCube_p WHERE sum_price / count_star < 5.00
Optimizer records each time a query uses a group, or could have used non-existent group; this helps with tuning