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

SQL History Tab

SQL History

The SQL History tab of the Preferences window allows users to specify which functions save the SQL statements. 

Keep a SQL record when these actions are performed

Optimize (Default = checked)

Save the SQL statement every time it is optimized in the SQL Optimizer module.

Run Time (Default = checked)

Save the SQL statement when the run time is retrieved using the Run Time function.

Execute in SQL Worksheet (Default = cleared)

Save the SQL statement when it is executed in the SQL Worksheet.

Show Plan (Default = checked)

Save the SQL statement every time the query plan is retrieved using the Show Plan function.

Run Result (Default = checked)

Save the SQL statement when it is executed using the Run Result function.

Advise Indexes (Default = cleared)

Save the SQL statement every time indexes are generated for it the Index Advisor module.

Maximum number of SQL to be stored (Default = 100)

Specify the maximum number of SQL statements that are stored in the SQL History.

Flush out SQL by

When the number of SQL statement in the SQL History reaches it maximum, the SQL statements removes SQL statements based on one of the following criteria:

Longest unused (Default)

Removes the SQL statement with the oldest date and time in the Last Used Datetime column.

Least frequently used

Removes the SQL statement with the lowest value in the Times Used column.

 

Related Topic

Plan Tab

Plan

Table Scan warning threshold (records)

Enter a threshold warning value for table scans between 1 and 2147483647. If the estimated rows for a table scan is larger than this value, the TableScan icon turns red. Otherwise, the TableScan icon is green.

Color

Specify the color of the individual items in the query plan by clicking the Color column in the row for the item and selecting the new color from the dialog.

Font

Specify the font settings of the individual items in the query plan by clicking the Font column in the row for the item and selecting the new settings from the dialog.

Note: To select which elements of the query plan that display when you are viewing the query plan, right-click and select Plan Options.

 

Related Topic

Related Documents