Creating Query Tuner projects

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:

  1. Click File > New > Query Tuner Project.
  2. Specify a name for the project.
  3. 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.
  4. 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.

Feedback