Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - 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 Worksheet Functions

SQL Worksheet > SQL Worksheet Functions

Below is a list of available functions within the Editor pane of the SQL Worksheet.

Button or Menu Function

Run Menu

image\B_Execute.gif image\B_AbortExecute.gif

Execute/Abort Execute

Run Menu



Run Menu




Syntax Highlight


Pairing Brackets


Argument Lookup


Member Lookup

Edit Menu



Edit Menu



Edit Menu



Edit Menu



Edit Menu



Edit Menu



Set & Right-click Menu

Toggle Bookmark

Set & Right-click Menu

Goto Bookmark

Set Menu

Previous Bookmark

Set Menu

Next Bookmark

Edit Menu


Send to SQL Optimizer

Edit Menu


Send to Index Advisor

All the settings for the Editor functions can be changed within the Preferences window under the Editor tab.

Below is the list of functions available in the Message Log in the SQL Worksheet window.

Menu Function

Right-click Menu


Right-click Menu

Clear All


Related Topics

SQL Formatter

SQL Formatter Overview

SQL Formatter > SQL Formatter Overview

The SQL Formatter transforms a SQL statement into a more readable format by automatically indenting and aligning the text, keeping a consistent SQL layout throughout the source code, and therefore making the SQL statement easier to read and understand. The SQL Formatter not only formats the SQL statement but also checks its syntax, and highlights parameters, forces, and comments.


Related Topics

SQL Formatter Window

SQL Formatter > SQL Formatter Window

The SQL Formatter window is divided into two sections:

Left Pane (Original SQL)

Provides an area for entering the SQL statement to be formatted.

Right Pane (Formatted SQL)

Displays the formatted SQL statement after the Format function is executed. Parameters, forces and comments are highlighted for ease of recognition. The color of the text is dependent on the syntax highlight definition set under the Editor tab in the Preferences.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating