Although you can tune SQL statements
without creating a
Query Tuner project, you can create a Query Tuner project before you
start tuning.
About this task
Query Tuner projects
are not required unless you are exiting
the workflow assistant and you want to save the recommendations and
analyses that you generated. When you close the workflow assistant,
a window asks you whether you want to save the recommendations and
analyses in a Query Tuner project. You do not need to create a project
before you start tuning.
Procedure
To create a
Query Tuner project:
- Click .
- Specify
a name for the project.
- Select an existing
connection or create a connection to
associate with the new project, and connect to the data server. Each Query Tuner project is associated with the connection profile
for a single data server. All of the SQL statements in a project must
run on the same data server.
- Click Finish to
create the project.
Results
The project is created.
The Project Explorer is refreshed
and displays the new project. When you use this method to create a
project, the new project contains one query group.