Page History
...
Click the SQL button on the Overview tab to specify the source of SQL statements you want to tune.
- New SQL Text: From the SQL button menu, select New SQL Text, and then copy/paste
...
Only the Elapsed Time statistic appears on all supported platforms. On Oracle, Execution Statistics and Other Execution Statistics columns will appear. When determining the best possible path using the Overview tab, it is best to use the Elapsed Time value as the guideline. The faster the path, the more optimized the query will become.
There are three tuning options to choose from before clicking Run Job:
...
- At the top right corner of the Tuning tab, click the Export Report button.
The Export a Tuning Report dialog appears. - Enter a Report Title and Description.
- On the Tuning Cases tab, choose the cases you want to report on. Click the + to expand the cases.
- On the Configuration tab, choose the content you want to include in the report.
- Select the General Report options, enter the location for the report, and then click Export.
You will see the progress of the report generation in the Progress pane.
When complete, the report is stored at the top level of your workspace.
A report in PDF format will resemble the following: