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
SQL statements to the SQL Text dialog or write queries by hand and then click OK.
| Info |
|---|
You can also input SQL by clicking anywhere in the Tuning Statements area and pressing Ctrl-V. |
...
- Extract from Database Objects: Search for and then select (Ctrl-click) data base objects containing SQL that you want to tune from the selected data source. SQL Query Tuner will search through the database to find objects matching your input and presents matches for you to choose. In order for this option to work, you must enable Data Source Indexing in the properties for the database. If the data source has not already been indexed you will receive a message indexing that no indexing information is available. You can configure the database Properties dialog from the Data Source Objects Selection dialog by clicking Configure data source indexing....
For information on setting data source indexing properties, see Specify Data Source Indexing Preferences. - Import from File (Workspace) and Import from File (System): Browse the workspace or file system and select an SQL file from which to extract statements to tune.
- Scan Oracle SGA: For the Oracle platform only, you can also scan the System Global Area (SGA) for statements to tune. Bind variables are extracted automatically.
- You can also drag and drop Materialized Views, Procedures, and Views from the Data Source Explorer to the Tuning Statements grid and they will be added to the list of statements to tune.
...
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: