SQL Optimizer for SAP ASE 3.9 - Installation Guide

Chat now with support

Chart Tab

Charts are available for all the statistics and run times. The Charts tab of the Run Time pane in the Index Advisor window displays two chart panes showing the run time information and statistics.

To change the information in the chart

Click the Chart Title and select one of the following functions:

Function		Description
Performance Projection		A performance forecast based on the retrieved Estimated I/O Cost value. If the Performance Projection value is greater then 1, then it is forecasted that the recommended Index candidate 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	Elapsed Time	Charts the execution time (in clock time) that it takes the SQL statement to select all records or the first record.
	Times of Improvement	How many times faster the alternative SQL statement is compared to the original SQL statement.
	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 disk writes for the SQL statement from the run time statistics.
	Scan Count	Charts the accumulative number of scans for the SQL statement from the run time statistics
	Logical Reads	Charts the accumulative number of logical reads for the SQL statement from the run time statistics
	Physical Reads	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 (Asynchronous-PreFetch I/Os) for the SQL statement from the run time statistics.
Other	All Records	Charts the Elapsed Time + CPU Time, Actual I/O Cost, and Times of Improvement for all records.
	First Record	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		Prints the chart.
Save		Saves the selected chart.
Hide Chart		Hides the selected chart.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

SQL Optimizer for SAP ASE 3.9 - Installation Guide

Chart Tab