Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - Installation Guide

SQL Optimizer Functions

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

SQL Editor and Optimized SQL Functions

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

Optimized SQL Functions

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

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating