Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - Installation Guide

General (SQL Scanner Tab)

Interface

Use color tabs for SQL classification (Default = checked)

When checked, the SQL statements are displayed with color-coded tabs representing the SQL's classification. Red for Problematic, purple for Complex, green for Simple, and blue for Invalid. If the SQL statement is checked, the tab is grey.

Show Checked SQL figures on the SQL Scanner window (Default = cleared)

When checked, an additional column of numbers is added to the SQL classification columns to indicate how many SQL statements have been checked for each Job. When a SQL statement is added to the Checked SQL list, it has a value in the appropriate SQL classification column in the SQL Scanner window.

Checked List

Action when performing Send to SQL Optimizer and Send to Index Advisor

Prompt user for action

If selected, the user is prompted to be added to the Checked List.

Always add SQL

If selected, all SQL sent is added to the Checked List.

Never add SQL (Default)

If selected, all SQL sent is not automatically added to the Checked List.

Do not remove Check SQL information when rescanning (Default = cleared)

Specify to keep the checked SQL information when the Job is rescanned. If unchecked, the checked SQL information is removed when the Job is scanned again.

Compare the current SQL with the rescanned SQL using

SQL text (Default)

Specify to match the SQL statements from the previous time the Job was scanned with the current scanning using only the SQL text as a comparison for the match. The checked SQL information is preserved for those SQL statements where the SQL text matches.

SQL text and query plan

Specify to match the SQL statements from the previous time the Job was scanned with the current scanning using the SQL text and the query plan as a comparison for the match. The checked SQL information is only preserved for those SQL statements where the query plan and the SQL text match.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating