General (SQL Scanner Tab)
View SQL Scanner - General page)
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.
If selected, all SQL sent is added to the Checked List.
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.