Chapter 4. Using the cube model for summary tables optimization 157
4.5.3 Run the Optimization Advisor
For the sample scenario, let us say we want to optimize the Sales Cube model
for drill through type of queries.
The next two things we need to plan for before running the Optimization Advisor
wizard are:
How much disk space we have for the summary tables and summary table
indexes
How much time we have to generate the recommendations
These are important because the Optimization Advisor will try to create
recommendations that is the most appropriate within the constraints that you
have. For our scenario, assume we have no time limit and have a disk space
limitation of 8 Gigabytes.
In the following sections we will go through the Optimization ...