Running the SQL Access Advisor

You run the SQL Access Advisor to get recommendations for improving the performance of a workload. You can run it on a periodic basis to avoid performance problems, or run it to verify schema change recommendations from the SQL Tuning Advisor.

To run the SQL Access Advisor:

1. Go to the Database Home page.

   See "Accessing the Database Home Page".

2. At the bottom of the page, under Related Links, click Advisor Central.

3. On the Advisor Central page, click SQL Advisors.

4. On the SQL Advisors page, click SQL Access Advisor.

   A page appears prompting you for initial options. Click Help for information about the options for this page.

5. Select an option, and then click Continue.

6. The Workload Source page appears. It is the first page of the SQL Access Advisor wizard.

   Click Help to obtain help for this and subsequent wizard pages. Follow directions and make the required selections for each wizard page, clicking Next when you are ready to proceed to the next page.

7. Continue through the wizard until you reach the Review page. Review your selections and then click Submit to start the analysis.

   The Advisor Central page appears, displaying a confirmation message indicating that your task has been started successfully.

8. Click the Refresh button (not your browser's Refresh icon) to view the status of your task.

9. When your SQL Access Advisor task has completed, select View Result.

   The Result for Task page appears.

   The Summary subpage shows you the potential for improvement under the headings Workload I/O Cost and Query Execution Time Improvement.

   
   Description of the illustration sqlaccess_adv_results.gif
   
   

   The Recommendations subpage shows the recommendations, if any, for improving performance. A recommendation might consist of, for example, a SQL script with one or more CREATE INDEX statements, which you can run by clicking Schedule Implementation.