Running SQL Access Advisor: Initial Options

The first step in running SQL Access Advisor is to select the initial options on the SQL Access Advisor: Initial Options page.

To select initial options: 

1. On the Database Home page, under Related Links, click Advisor Central.

   The Advisor Central page appears.

2. Under Advisors, click SQL Advisors.

   The SQL Advisors page appears.

3. Click SQL Access Advisor.

   The SQL Access Advisor: Initial Options page appears.

4. Do one of the following:

   • Select Verify use of access structures (indexes, materialized views, partitioning, and so on) only to verify existing structures.

   • Select Recommend new access structures to use the recommended options defined in the Oracle Enterprise Manager default template.

     If you select this option, then you can optionally complete the following steps:

     • Select Inherit Options from a previously saved Task or Template to use the options defined in an existing SQL Access Advisor task or another template.

     • In Tasks and Templates, select the task or template that you want to use.

5. Click Continue.

   The SQL Access Advisor: Workload Source page appears.

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