SQL Optimizer for DB2 LUW 4.3.1

The Goto Line search function brings up the Goto Line window where you can enter the line number that you want to move the cursor to. It is not necessary to have the line numbers displayed in the gutter to use this function, but it would certainly be helpful to see the line numbers in order to select the line number to move the cursor to.

To move the cursor to the beginning a of specific line

Select Search | Goto Line [Ctrl + Alt + G].
Enter the line number.

Regular Expression

Regular expressions are characters that customize a text search string. They formulate a more complex search.

You must select the Regular expression checkbox to use these advanced search features.

Type of Search	Search Characters	Location of character in the search string	Explanation
Text at the beginning of line.	^ (circumflex) Example: ^select	Beginning	A circumflex at the beginning of the text search string finds the text only if it is the first non whitespace text on a line.
Text at the end of line.	$ (dollar sign) Example: error$	End	A dollar sign at the end of the expression matches the end of a line.
Single character wildcard	. (period) Example: f.r matches "for" and "‘far"	Any place	A period represents any character.
Class of character	: (colon) Example: SQL:a finds SQLSTATE or SQLTABLE SQL:d Finds SQL1 or SQL3	Any place	A colon matches a class of characters described by the character following the colon. :a matches any alphabetic character :d matches a digit :n matches an alphanumeric character ": " matches a space, tab, or other control character or punctuation mark (ASCII 0x01 - 0x40)
Search for Regular Expression characters	\ (backslash) Example: \^ searches for ^ \\ searches for \.	Any place	A backslash before a wildcard character searches for actual character and does not use the character as a wildcard.
Search for multiple characters in one position	[...] (characters within brackets) Example: r[au ]n finds run or ran	Any place	Characters enclosed in brackets matches any one character that appears in the brackets, but no others. Nesting of brackets is not supported.
Search for any character but the specified characters in one character position	[^] (circumflex within square brackets) Example: r[^oa ]n finds run, r n, rin , etc but not ron or ran.	Any place	A circumflex at the start of the string in square brackets means NOT. The expression matches any character except the characters in the string and the carriage return (ASCII 0x0D) or line feed (ASCII 0x0A).
Search for a range of characters in one character position	[-] (hyphen within the brackets) Example: SQL[1-3] finds SQL1, SQL2 and SQL3	Any place	A hyphen within the brackets signifies a range of characters. Note: the range must be in a progressive order, i.e. "[a-x]" matches any character from a through x while "[x-a]" does not match anything.

Activity Log

Quest SQL Optimizer for IBM® DB2® LUWmaximizes SQL performance by automating the manual, time-intensive and uncertain process of ensuring that SQL statements are performing as fast as possible. SQL Optimizer analyzes, rewrites, and evaluates SQL statements within multiple database objects, files, or SQL statements captured by the DB2 Event Monitor. With SQL Optimizer, you can analyze and optimize all your problem SQL from multiple sources. SQL Optimizer also provides you a complete index optimization and plan change analysis solution, from index recommendations to simulated index impact analysis, through comparison of multiple SQL access plans.

SQL Optimizer provides you with the following main modules.

SQL Optimizer (including SQL Rewrite and Generate Indexes functions)

Index Impact Analyzer

Index Usage Analyzer