Managing SQL categories

Use the SQL Category view to save SQL SQL statements for future tuning activities and as a source when capturing SQL statements for tuning.

About this task

The SQL Category view provides a facility for storing SQL statements for future tuning activities.

Procedure

  1. If the view is not open, select Window > Show View > SQL Category, or click the SQL Category tab.
  2. Follow any of these steps:
    • To create a new category, click Add category, and enter a unique name for the category in the Create Category dialog. You can also rename existing categories.
    • To add a query to a category, click Add SQL. Specify the category and type or paste the text of the query into the SQL Text field. You can also specify a name and comments for the query.
    • To modify the name, text, or comments of an existing query, select the query in the table, click Update SQL, and change the contents of the fields in the Update SQL dialog.
    • To copy a query from one category into another category, select the query in the table and click Copy SQL.
    • To delete an existing category or query, select it in the table and click Delete.

Feedback