When you double-click a query node in a Query Tuner project, the Query Tuner Workflow Assistant opens to the Invoke section and the SQL statement appears in the Query Text field. You can run the advisors and tools, or you click the Review tab to open the Review section and view the current or saved analysis results.
When there is more than one query node in a project, you can switch between their SQL statements in the Invoke section of the workflow assistant. To switch, in the top-left corner of the Invoke section select the query node that contains the SQL statement. This corner of the Invoke section lists the query groups that are in the current project and the query nodes within those query groups.
When you double-click an analysis result in a Query Tuner project, the Query Tuner Workflow Assistant opens, so that you can review the content of that analysis result. You can also review all of the analysis results for an SQL statement for that statement over time. In the Review section, you can switch between analysis results by selecting them in the top-left corner. You can rename an analysis result by right-clicking it in the Project Explorer or in the workflow assistant and selecting Rename. The new name appears in both the Project Explorer and the workflow assistant.
The reports that you generate are also listed in the Review section of the workflow assistant. You can rename a report by right-clicking it in the Project Explorer or in the workflow assistant and selecting Rename. The new name appears in both the Project Explorer and the workflow assistant.
When there are two or more workload nodes in a project, you can switch between their query workloads in the Invoke section of the workflow assistant. To switch, in the top-left corner of the Invoke section select the workload node that represents the query workload. This corner of the Invoke section lists the workload groups that are in the current project and the workload nodes within those workload groups.
In each workload node, only a single analysis result for the corresponding query workload is available. An analysis result is represented by its corresponding workload node.
If any workload table reports are generated for a workload, the reports appear under the workload node in the Review section. You can rename a workload group, workload node, or report by right-clicking it in the Project Explorer or in the workflow assistant and selecting Rename. The new name appears in both the Project Explorer and the workflow assistant.