Dropping a SQL Tuning Set

This section describes how to drop a SQL Tuning Set. To conserve storage space, you may want to periodically drop unused SQL Tuning Sets stored in the database.

To drop a SQL Tuning Set: 

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

   The SQL Tuning Sets page appears.

   Existing SQL Tuning Sets are displayed on this page.

2. Select the SQL Tuning Set you want to drop and then click Drop.

   The Confirmation page appears to verify that you want to drop the selected SQL Tuning Set.

3. Click Yes.

   The SQL Tuning Sets page appears.

   A confirmation message is displayed to indicate that the SQL Tuning Set was successfully dropped.