Cubing — Cubing Services Optimization Advisor

The Cubing Services Optimization Advisor enables high performance for large cubes. The Advisor provides recommendations about which MQTs and indexes to build to improve SQL queries that are executed against the star schema tables.

Because the Optimization Advisor function does sampling on rows in the tables, in the Design Studio the Optimization Advisor can be run only against a cube model in the Database Explorer. In addition, the Optimization Advisor can be invoked from the Administration Console.