Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - User Guide

Introduction Tutorials Preferences Editor Functions SQL Information and Functions Performance Monitor SQL Inspector SQL Collector for Monitor Server SQL Scanner Index Advisor SQL Optimizer
SQL Optimizer Overview Optimization Engine Common Coding Errors in SQL Statements What Function Should l Use to Retrieve the Run Time? Unsatisfactory Performance Results SQL Optimizer Functions SQL Editor Optimized SQL Activity Log
SQL Worksheet SQL Formatter Database Explorer Code Finder Object Extractor SQL Repository Index Impact Analyzer Index Usage Analyzer Configuration Analyzer Migration Analyzer Abstract Plan Manager User-Defined Temp Tables SQL History Legal Information

SQL Scanner Functions

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

Button or Menu Function

Group & Right-click Menu

image\B_AddJobs.gif

Add Jobs

Group & Right-click Menu

Delete Marked Jobs

Group Menu

Mark All

Group Menu

Unmark All

Group Menu

Copy to Other Group

Group Menu

Move to Other Group

Group Menu

image\B_GroupManager.gif

Group Manager

Job Menu

image\B_Scan.gif image\B_AbortScan.gif

Scan/Abort Scan

Job Menu

Find Job

Job Menu

Checked List

SQL & Right-click Menu

Open in SQL Inspector

SQL & Right-click Menu

Open in SQL Collector

SQL & Right-click Menu

Checked List

SQL Menu

image\B_SaveAbstractPlan.gif

Save Abstract Plan

SQL Menu

Find SQL

SQL Menu

Find Next SQL

Report Menu

Scanned SQL Report

Report Menu

Group Summary

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

View Menu

All SQL

View Menu

Simple SQL

View Menu

Complex SQL

View Menu

Problematic SQL

View Menu

Invalid SQL

View Menu

Checked SQL

View Menu

Unchecked SQL

Edit Menu

image\B_SendToSQLOptimizer.gif

Send to SQL Optimizer

Edit Menu

image\B_CopytoIndexAdvisor.gif

Send to Index Advisor

Edit Menu

image\B_CopyToSQLWorksheet.gif

Copy to SQL Worksheet

File Menu

Save SQL to SQL Repository

Right-click Menu

Add/Remove Bookmark

Right-click Menu

Modify

Right-click Menu

Use Database

Right-click Menu

Set User

Right-click Menu

View (Large Icons/ Small Icons/ List/ Details)

Right-click Menu

Mark Selected Jobs

Right-click Menu

Unmark Selected Jobs

Right-click Menu

Properties

Right-click Menu

Save

Right-click Menu

Create Benchmark Factory Import File

 

Related Topics

SQL Scanner Window

SQL Conversion

SQL Conversion Overview

In order to render the SQL statement as a valid standalone SQL a number of conversions maybe applied to the SQL statement.

Note: If a conversion is applied, it may be necessary to reverse the changes after optimization when an alternative SQL is pasted back to the original source code.

 

Related Topic

Trigger Conversion

During a trigger operation, two logical tables store deleted and inserted records. The deleted and inserted logical tables cannot be referenced outside the trigger body. Therefore to be able to optimize a SQL statement used in a trigger two temporary tables are used to simulate the inserted and deleted tables.

For example:

Original SQL statement

INSERT INTO EMP_SMALL (EMP_ID,

EMP_NAME,                        

EMP_SALARY)                        

SELECT A.EMP_ID,

A.EMP_NAME,        

B.EMP_SALARY        

FROM EMPLOYEE A,   

Inserted B       

WHERE A.EMP_ID = B.EMP_ID 

After conversion

SELECT *

INTO #inserted_simulation_table   

FROM dbo.EMPLOYEE  

WHERE 1 = 2 

INSERT INTO EMP_SMALL (EMP_ID,

EMP_NAME,                        

EMP_SALARY)                        

SELECT A.EMP_ID,

A.EMP_NAME,        

B.EMP_SALARY        

FROM EMPLOYEE A,   

#inserted_simulation_table B       

WHERE A.EMP_ID = B.EMP_ID 

 

Related Topic

Related Documents