Page History
...
- The Generated case Expand/Collapse control lets you hide or display the hint-based cases and transformation-based case generated for a statement.
- The Perform detail analysis and Execute each generated case check boxes let you enable multiple statements or cases for simultaneous execution while the Run/Cancel Job controls let you start and stop simultaneous execution.
- Use the Schema and Catalog Selectors to select a schema and catalog for the tuning job.
The catalog selector is available only for SQL Server and Sybase data sources. By specifying the schema and catalog, the tuner can use the paths of the schema and catalog selected to find the tables queried in the job rather that use the paths of the schema and catalog used to connect to the data source. If you change the schema or catalog used in a tuning statement you will need to refresh the tuning statements in order for new cases to be generated, which take into consideration the schema used. Right-click a tuning statement, and then select Refresh Tuning Statements. - The Column set Expand/Collapse controls let you expand a column set to display more of the columns within the table.
- The Tuning Status Indicator indicates whether a statement or case is ready to execute or has successfully executed. The following table provides information on the Tuning Status Indicator states:
| Icon | Description |
|---|---|
| The case has not been executed. There are no errors or warnings and the case is ready to be executed. |
| The case has been successfully executed. |
| Execution for this case failed or was cancelled due to execution time exceeding 1.5 of original case time. |
Hovering the mouse over the Tuning Status Indicator displays a tip that notes the nature of a warning or error.
| Info |
|---|
If a warning |
A warning can indicate an object caching error. For example, a table may not exist or not be fully qualified. Cases cannot be generated for the associated statement.
The explain plan-based Cost field can be expended to display a graphical representation of the values for statements or cases. Similarly, after executing a statement or case, the Elapsed Time field can be expanded to display a graphical representation. The bar length and colors used in the representation are intended as an aid in comparing values, particularly among cases. For example:
In the case of both Cost and Elapsed Time, the values for the original statement are considered the baseline values. With respect to color-coding for individual case variants, values within a degradation threshold (default 10%) and improvement threshold (default 10%) are represented with a neutral color (default light blue). Values less than the improvement threshold are represented with a distinctive color (default green). Values greater than the degradation threshold are shown with their own distinctive color (default red).
With respect to bar length, the baseline value of the original statement spans half the width of the column. For child-cases of the original statement, if one or more cases show a degradation value, the largest degradation value spans the width of the column. Bar length for all other children cases is a function of the value for that case in comparison to the highest degradation value.Info For information on specifying colors, and the improvement threshold and degradation threshold values used in these graphical representations, see Specify Tuning Job Editor preferences.
...