Description of the illustration sql_access_source_cache.gif

The screenshot shows the SQL Access Advisor: Workload Source page.

Below the title of the page are the following label-value pairs: Database is empdb, Logged In As is DBA1.

The Cancel and Next buttons are on the right. Between the buttons is the text "Step 1 of 4".

The following text describes a set of options: "Select the source of the workload that you want to use for the analysis. The best workload is one that fully represents all the SQL statements that access the underlying tables."

The options are the following:

• Current and Recent SQL Activity

  The option has the associated text, "SQL will be selected from the cache."

• Use an Existing SQL Tuning Set

  The option has the associated SQL Tuning Set field. To the right of the field is a search icon.

• Create a Hypothetical Workload from the Following Schemas and Tables

  The option has the associated text, "The advisor can create a hypothetical workload if the tables contain dimension or primary/foreign key constraints." It also has the Schemas and Tables field. The field has an associated Add button and the text, "Comma-separated list." The option has the associated tip, "Enter a schema name to specify all the tables belonging to that schema."

End of description.