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

Bookmarks

Bookmarks can be set to quickly return to a place in your code. To set a bookmark, right-click, select Toggle Bookmark or select Set | Toggle Bookmark and then pick a bookmark number between 0 and 9. The bookmark number displays in a field in the gutter in place of the line number.

To move the cursor to a bookmark

  1. Right-click and select Goto Bookmark.

  2. Select your bookmark number.

To move to the next or previous bookmark

Select Set | Previous/Next Bookmark.

 

Related Topic

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

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

Related Documents