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

Result Set (General Tab)

The Result Set page on the General tab of the Preferences window allows you to set preferences for editing data.

Edit data

Auto commit when finished editing (Default = cleared)

Specify to automatically commit the data when editing the data in the data girds.

 

Batch Run (General Tab)

The Batch Run page of the General tab of the Preferences window allows you to set preferences for the Batch Run.

Batch Run for Optimization Description

Automatically start Batch Run after Optimization

If selected, batch run starts automatically after Optimization.
Batch Run for Index Advisor Description

Automatically start Batch Run after Index Advisor

If selected, batch run starts automatically after Index Advisor.

 

Editor Tab

Editor

The Editor tab of the Preferences window allows you to define the editable panes control and layout.

General

Use tab characters (Default = cleared)

Specify whether to use the tab character (ASCII 9) instead of spaces.

Smart tab (Default = checked)

Specify whether the tab aligns with the next non-whitespace character of the previous line.

Bracket pairing (Default = checked)

Specify whether to match the corresponding opening bracket when the ending bracket is typed.

Use lowercase for object name (Default = checked)

Specify whether to use lowercase for database object names or have them displayed in uppercase.

Block cursor for overwrite mode (Default = checked)

Specify whether to use the block cursor when in overwrite mode. Overwrite mode is when text entered at the cursor overwrites the existing text.

Show all characters (Default = cleared)

Specify whether to display all characters including spaces, carriage return and tabs on the screen.

Show gutter (Default = checked)

Specify whether to show a non-editable boarder on the left of the Editor pane.

Width (Default = 34, Range = 1 to 100 pixels)

Specify the gutter width in pixels.

Show line numbers in gutter (Default = checked)

Specify whether to show line numbers in the gutter.

Apply to SQL Worksheet only (Default = checked)

Specify to display the line number in the gutter only in the SQL Worksheet module when the Show line numbers in gutter option is selected. If not selected, the line numbers are displayed in all windows where you can enter and edit SQL text.

Show right margin ((Default = checked)

Specify whether to show a vertical line at the right margin.

Width (Default = 80, Range = 1 to 1000 characters)

Specify the width of the page or the right margin position.

Block indent size (Default = 3, Range = 1 to 20)

Specify the block indent size in characters.

Tab size (Default = 3, Range = 1 to 20)

Specify the character length of a tab.

Editing

Syntax highlight (Default = checked)

Specify whether to use syntax highlight. If selected, it is possible to define the format for the following syntax: reserved word, SQL function, comment, identifier, quoted identifier, string, number, symbol, data type, global variable, local variable, temporary table, system procedure, invalid object, force, difference highlight (for SQL Comparer), text selection, member lookup and argument lookup.

Auto correction (Default = checked)

Specify whether to automatically correct typing errors and abbreviations as characters are typed. Allows the addition, editing and deletion of the auto correction entries. Also allows the specification of the action key that triggers the automatic replacement.

Lookup

Member Lookup (Default = checked)

Specify whether to show the lookup hint for database object members. For example, displays a list column names when a table name or alias name is followed by a period.

Argument Lookup ((Default = checked)

Specify whether to show the argument parameters hint for database functions and procedures. These hints display when the opening bracket is typed.

Delay (Default = 0.75 sec, Range = 0.5 to 1.5 sec)

Specify the delay time before the lookup hint displays.

 

Related Topic

Related Documents