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 Tab

SQL Worksheet

Preferences > SQL Worksheet Tab > SQL Worksheet

The SQL Worksheet tab of the Preferences window allows users to determine if the commands are clear upon execution, the batch separator, the buffer size for the result set, and to specify how the results sets are displayed.


Clear commands upon execution (Default = checked)

Specify to clear the SQL statement or Transact-SQL code in the Editor pane after the command is successfully executed. If the execution is not successful, then the text remains in the Editor pane.

If this option in not selected, the text also remains in the Editor pane.

Note: After a successful execution, the text is always saved in the Command drop-down field at the top of the window.

Batch Separator (Default: GO)

Specify the separator used to signal the end of a batch of Transact-SQL statements.

Result buffer size

Unlimited or Fixed size (records)

Select Unlimited to return all records. Select Fixed size and then in the text field, set the maximum number of records to be returned. (Default fixed size: 1000)

Display results

Maximum characters per column: (Default: 256)

Specify how wide each column should be in the Resultn tab in the lower pane of the SQL Worksheet window.

Discard results: (Default: cleared)

Specify whether to show the results on the Resultn tab, or to just show the number of affected records on the Message Log tab.

Display results in

Grid or Text: Select between displaying the results in a grid or in plain text.

Under the Text option you can also select:

Output format (Default: Column aligned)

Select between Column aligned, Comma separated (CSV), Tab delimited, or Other delimiter.

Right aligned numerics: (Default: cleared)

When you select Column aligned for the Output format, specify whether or not to right align number columns.


When you select Other delimiter for the Output format, specify the character to be used as the delimiter between the columns.

Display headers:

Specify whether or not the column names are displayed.


Related Topic

SQL Scanner Tab

SQL Scanner

Preferences > SQL Scanner Tab > SQL Scanner

The SQL Scanner settings are used to define the requirements for the SQL Scanner module.

SQL Scanner Options Settings

SQL Scanner Abstract Plan Settings

SQL Scanner General Settings

The settings in the SQL Classification tab are used by the SQL Scanner to help you identify which SQL statements are likely to be causing performance problems by classifying the SQL as Problematic, Complex, or Simple.

SQL Classification Settings


Related Topic

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating