Select Queries (Usage-Based Optimization Wizard)
In this step of the wizard, you select the queries on which you want to base your optimization. You can specify:
- Queries between two dates
- Queries by specific users
- Length of time that a query takes to return a result set
- Numbers of times a query has been run
- Queries sent to one of the specific data storage types used in your cube
- A combination of any number of these
Options
Queries for the dates
Select to set the date range for queries on which you want the wizard to base optimization. To choose the date range type, use the drop-down list to select Between, Before, or After. The options available under this check box change depending on the date range type.
- Between
To use all queries between a desired start date and end date for optimization, enter the desired start date in the following text box, or click the expand (...) button to select the desired start date. Then, enter the desired end date in the last text box, or click the expand (...) button to select the desired end date.
- Before
To use all queries on or before a desired date for optimization, enter the desired date in the following text box, or click the expand (...) button to select the desired date.
- After
To use all queries after a desired date for optimization, enter the desired date in the following text box, or click the expand (...) button to select the desired date.
Queries by these users
Select to add users and groups of users whose queries you want the wizard to base optimization on. Because the available users and groups are defined based on user roles, you cannot filter by users unless you have defined user roles. For more information about roles, see Database, Cube, and Mining Model Roles.
- Add
Click to display the Select Users dialog box, which you can use to select users from the list of available users.
- Remove
Click to remove a selected user or group from the list.
Queries that ran more than
Select to tell the wizard to optimize based only on queries that were sent more than a certain number of times. Choose the number in the box provided.
Queries that took longer than
Select to tell the wizard to optimize based only on queries that took longer than a certain amount of time. Use the two boxes provided to specify the number of seconds or minutes.
Queries to
Select to tell the wizard to optimize performance based only on queries to a certain type of data storage object.
- MOLAP cubes
Select to optimize aggregations based on queries to multidimensional OLAP (MOLAP) cubes.
- ROLAP tables
Select to optimize aggregations based on queries to relational OLAP (ROLAP) tables.
- The server cache
Select to optimize aggregations based on lookup queries to the server cache.