Chat now with support
Chat mit 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

image\B_Edit.gif

Edit

Run Menu

image\B_sp_help.gif

SP_HELP

 

Syntax Highlight

 

Pairing Brackets

 

Argument Lookup

 

Member Lookup

Edit Menu

image\B_Indent.gif

Indent

Edit Menu

image\B_Outdent.gif

Outdent

Edit Menu

image\B_Comment.gif

Comment

Edit Menu

image\B_Uncomment.gif

Uncomment

Edit Menu

image\B_Uppercase.gif

Uppercase

Edit Menu

image\B_Lowercase.gif

Lowercase

Set & Right-click Menu

Toggle Bookmark

Set & Right-click Menu

Goto Bookmark

Set Menu

Previous Bookmark

Set Menu

Next Bookmark

Edit Menu

image\B_SendToSQLOptimizer.gif

Send to SQL Optimizer

Edit Menu

image\B_CopytoIndexAdvisor.gif

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

Save

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

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen