Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9 - 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 > 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

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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating