Analyze Chart Results
View Chart Results Window
Charts are available for all the statistics and run times. Three chart panes display the run time information.
To change the information in the chart
Click the Chart Title and select the following functionality:
Performance Projection
A performance forecast based on the retrieved Estimated I/O Cost value. If the Performance Projection value is greater then one, then it is forecasted that the SQL alternative may give a better performance.
Estimated I/O cost
Charts the estimated I/0 cost from the SQL statement with the corresponding indexes.
All Records and First Record
Charts the following statistics for All Records or First Record after the run time is retrieved for a SQL statement using the Batch Run, Run for All Records, or Run for First Record.
| Statistics | Description |
| Elapsed Time | Charts the execution time (in clock time) that it takes the SQL statement to select all records or the first record. This figure may include time that Adaptive Server spent on processing other tasks or waiting for disk or network I/O to complete. |
|
Times of Improvement |
How many times faster the alternative SQL statement is compared to the original SQL. |
|
CPU Time |
Charts the execution time (in CPU time) that it takes the SQL statement to select all records or the first record. |
|
Actual I/O Cost |
Charts the Actual I/O Cost of executing the SQL statement from Adaptive Server. |
|
Elapsed Time + CPU Time |
Charts side by side the Elapsed Time and the CPU Time. |
|
Writes |
Charts the accumulative number of disks writes for the SQL statement run time statistics. |
|
Scan Count |
Charts the accumulative number of scans for the SQL statement from the run time statistics. |
|
Logical Read |
Charts the accumulative number of logical reads for the SQL statement from the run time statistics. |
|
Physical Read |
Charts the accumulative number of physical reads for the SQL statement from the run time statistics. |
|
Apf IOs used |
Charts the accumulative number of Apf IOs for the SQL statement from the run time statistics. |
Other
Charts the following statistics.
|
Statistics |
Description |
| All Records | Charts the Elapsed Time + CPU Time, Actual I/O Cost, and Times of Improvement for all records. |
|
First Records |
Charts the Elapsed Time + CPU Time, Actual I/O Cost, and Times of Improvement for the first record. |
|
All Records vs. First Record |
Charts the Elapsed Time for all records and the first record. |
|
All Records vs. First Record with Cost |
Charts the Estimated I/O Cost, the Elapsed Time + CPU Time (for all records), and Elapsed Time + CPU Time (for the first record). |
Print the chart.
Save
Save the selected chart.
Hide Chart
Hide the selected chart.