SQL Optimizer for SAP ASE 3.8

Chat now with support

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

SQL Editor Functions

These functions are available only in the SQL Editor.

Button or Menu	Function
SQL Menu $image\B_Optimize.gif$ $image\B_AbortOptimize.gif$	Optimize/Abort Optimize
SQL Menu $image\B_OptimizeUsingAP.gif$ $image\B_AbortOptimizeUsingAbstractPlan.gif$	Optimize Using Abstract Plan/Abort Optimize Using Abstract Plan
SQL Menu $image\B_ShowPlan.gif$	Show Plan
SQL Menu	Show Default Plan
File Menu	Open SQL from SQL Repository

These functions are available for both the SQL Editor and Optimized SQL.

Button or Menu	Function
SQL Menu $image\B_RunResult.gif$ $image\B_AbortRunResut.gif$	Run Result/Abort Run Result
SQL Menu $image\B_RunForFirstRecord.gif$ $image\B_AbortRunForFirstRecord.gif$	Run for First Record/Abort Run for First Record
SQL Menu $image\B_RunForAllRecords.gif$ $image\B_AbortRunForAllRecords.gif$	Run for All Records/Abort Run for All Records
SQL & Right-click Menu $image\B_TestForScalability.gif$	Testing for Scalability
SQL Menu	Open Optimized SQL
Edit Menu $image\B_CopytoIndexAdvisor.gif$	Send to Index Advisor
Edit Menu $image\B_CopyToSQLWorksheet.gif$	Copy to SQL Workshop
File Menu	Save to SQL Repository
Right-click Menu	Create Benchmark Factory Import File

These functions are available only for the Optimized SQL.

Button or Menu	Function
SQL Menu $image\B_BatchRun.gif$ $image\B_AbortBatchRun.gif$	Batch Run/Abort Batch Run
SQL Menu $image\B_AbstractPlanMatrix.gif$	Abstract Plan Matrix
SQL Menu $image\B_SaveAbstractPlan.gif$	Save Abstract Plan
SQL Menu $image\B_SQLComparer.gif$	SQL Comparer
SQL Menu	Save Optimized SQL
SQL Menu	Find SQL. . . /Find Next SQL
Navigate Menu $image\B_FirstSQL.gif$ $image\B_PreviousSQL.gif$ $image\B_NextSQL.gif$ $image\B_LastSQL.gif$	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