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.