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. Access the Database Home page.

   See "Accessing the Database Home Page" for more information.

2. From the Performance menu, select SQL, and then SQL Tuning Sets.

   If the Database Login page appears, then log in as a user with administrator privileges. The SQL Tuning Sets page appears.

3. Click Create.

   The Create SQL Tuning Set: Options page appears.

4. 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.

5. 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.

6. Click Next.

   The Create SQL Tuning Set: Load Methods page appears.

   
   Description of the illustration sts_load_methods.gif

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