Creating a SQL Tuning Set: Options

The first step in creating a SQL Tuning Set is to specify options for the set such as name, owner, and description.

To specify options for creating a SQL Tuning Set: 

1. On the Database Performance page, under Additional Monitoring Links, click SQL Tuning Sets.

   The SQL Tuning Sets page appears.

2. Click Create.

   The Create SQL Tuning Set: Options page appears.

3. Enter the following details:

   • In SQL Tuning Set Name, enter a name for the SQL Tuning Set.

   • In Owner, enter the owner of the SQL Tuning Set.

   • In Description, enter a description of the SQL Tuning Set.

4. Optionally, to create an empty SQL Tuning Set and add SQL statements to it at a later time, complete the following steps:

   1. Select Create an empty SQL tuning set.

   2. Click Next.

      The Create SQL Tuning Set: Review page appears.

   3. Review your SQL Tuning Set options and click Submit.

      The empty SQL Tuning Set is created. You can add SQL statements to it later.

5. Click Next.

   The Create SQL Tuning Set: Load Methods page appears.

6. Proceed to the next step, as described in "Creating a SQL Tuning Set: Load Method".