Usage-Based Optimization Wizard - Select Queries

In this step of the wizard you select the queries you want to base your optimization on. 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 the above

To base your optimization on all the queries that ran during a specific time period

1. Select the Queries for the dates check box.
2. Select Between, Before, or After.
3. Click the “…” button to select dates for one or both date boxes.
4. Click Next.

To base your optimization on queries by one or more specific users

1. Select the Queries by these users check box.
2. Use the Add and Remove buttons to build your list of users.
3. Click Next.

To base your optimization on all the queries of a certain duration

1. Select the Queries that took longer than check box.
2. In the second box, select Seconds or Minutes.
3. In the first box, type or select a number.
4. Click Next.

To base your optimization on queries that ran a certain number of times

1. Select the Queries that ran more than check box.
2. Type or select a number in the times box.
3. Click Next.

To base your optimization on queries to data stored in a specific mode

1. Select the Queries to check box.
2. Click MOLAP cubes, ROLAP tables, or The server cache. The server cache option bases optimization on queries that were resolved solely by accessing the memory of the server computer without accessing a storage device.
3. Click Next.

To base your optimization on more than one query criterion

1. Select all the options you want to include.
2. Fill in the details for each option.
3. Click Next.