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
- If
the view
is not open, select , or click the SQL Category tab.
- 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.