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

Switch View in SQL Comparer Window

The sections of the SQL Comparer window can be switched from horizontal to vertical and vice versa.

To switch the display orientation

Click image\B_Rotate.gif.

 

Related Topic

SQL Comparer Functions

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

Menu or Button Function

Compare Menu

image\B_Compare.gif image\B_StopCompare.gif

Start Compare / Stop Compare

Compare Menu

image\B_Rotate.gif

Rotate

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

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

 

Related Topics

Activity Log

Activity Log Overview

The Activity Log is designed to provide management reports on the effective usage of SQL Optimizer on each individual client PC. The Activity Log records the activities during the SQL optimization process and query plan generation. The information recorded can be used to review the number of SQL statements analyzed, number of SQL statements optimized, percentage of performance improvement and also the original SQL text and the best alternative SQL.

 

Related Topics

Related Documents