Using a Hypothetical Workload

A dimension table stores all or part of the values for a logical dimension in a star or snowflake schema. You can create a hypothetical workload from dimension tables containing primary or foreign key constraints. This option is useful if the workload to be analyzed does not exist. In this case, SQL Access Advisor examines the current logical schema design, and provides recommendations based on the defined relationships between tables.

To use a hypothetical workload as the workload source: 

1. On the SQL Access Advisor: Workload Source page, select Create a Hypothetical Workload from the Following Schemas and Tables.

2. Leave Schemas and Tables empty and then click Add to search for tables.

   The Workload Source: Search and Select Schemas and Tables page appears.

3. In the Tables section, enter a schema name in the Schema field and then click Search.

   A list of tables in the selected schema is displayed.

4. Select the tables to be used in creating the hypothetical workload and then click Add Tables.

   The selected tables now appear in the Schemas and Tables field.

5. Click OK.

   The SQL Access Advisor: Workload Source page appears with the selected tables now added.

6. Proceed to the next step, as described in "Running SQL Access Advisor: Filter Options".