SQL Optimizer Functions

Below is a list of available functions within the SQL Optimizer window.

These functions are available only for the original SQL statement <Edit SQL> when displayed in the editable SQL Text window.

Button or Menu	Function
SQL Menu	Optimize/Abort Optimize
SQL Menu	Show Plan
SQL Menu	Convert Parameter Markers
File Menu	Open SQL from SQL Repository

 

These functions are available for original SQL and its alternatives.

Button or Menu	Function
SQL Menu	Run Result/Abort Run Result
SQL Menu	Run for First Record/Abort Run for First Record
SQL Menu	Run for All Records/Abort Run for All Records
Right-click Menu	Plan Help
SQL Menu	Open Optimized SQL
File Menu	Save SQL to SQL Repository
SQL Menu	Add User-Defined SQL
SQL & Right-click Menu	Test for Scalability
Right-click Menu	Create Benchmark Factory Import File

 

These functions are available only after the original SQL statement has been rewritten or virtual indexes have been generated.

Button or Menu	Function
SQL Menu	Batch Run/Abort Batch Run
SQL Menu	Save Optimized SQL
Search Menu	Find SQL. . . /Find Next SQL
	First SQL/ Previous SQL/ Next SQL/ Last SQL
Navigate Menu	Go to SQL
Report Menu	Optimized SQL
View Menu	Show Optimization Details
View Menu	Show Batch Run Details
View Menu	Show Open Optimized SQL Details
View Menu	Show Refresh Plan Details