SQL Optimizer for SQL Server 10.1.2 - User Guide

Scan SQL

To set scan SQL options

1. Click in the main menu.

2. Select Scan SQL | Options.

3. Review the following for additional information:

   Automatically start scanning SQL when a job is added	Select this checkbox to start SQL Scanner automatically after you add a scan job.
   Skip SQL within comments	Select this checkbox to ignore SQL statements within comments enclosed by /* */, // and –- in the source code. By default, the scanning algorithm searches for SQL statements contained in comments.
   Skip SQL that does not access any tables	Select this checkbox to ignore SQL statements that do not access tables.
   Whole word matching for the first SQL keyword	Select this checkbox to search for SELECT, INSERT, UPDATE or DELETE as a whole word. When selected, these keywords must be preceded and followed by a space or end of line character. For example, SQL Scanner will not find the word INSERT if it is included in PROCEDUREINSERT.
   Create Scanner Temp Table	Select this checkbox to automatically create a temporary table during scanning when SQL Scanner finds a CREATE TABLE #TEMP or a SELECT INTO #TEMP statement. SQL Scanner automatically drops tables created at the end of the scanning process.
   Include data	Select this checkbox to automatically execute INSERT, DELETE, UPDATE, and SELECT INTO statements that modify temporary tables SQL Scanner created. Note: Selecting this option may increase total scanning time if SQL Scanner has to load a significant amount of data into the temporary table.
   Override previous Scanner Temp Table	Select this checkbox to have SQL Scanner create a new temporary table each time it finds a new CREATE TABLE or SELECT INTO statement. Note: Selecting this option does not override User-Defined temporary tables.
   Override User-Defined Temp Table	Select this checkbox to have SQL Scanner overwrite an existing User-Defined temporary table when it finds a statement to create a table that uses the same name. Note: Selecting this option does not override temporary tables SQL Scanner created.
   Number of characters to skip at the beginning of every line when scanning	Enter the number of characters you want SQL Scanner to skip at the beginning of each line during scanning.
   Skip end of line continuation character	Select the continuation character you want SQL Scanner to skip at the end of each line during scanning.

Related Topics

About Scanning SQL

Scan SQL

About Temporary Tables

Use Temporary Tables in Scan SQL

Scan SQL Options

To set scan SQL options

1. Click in the main menu.

2. Select Scan SQL | Options.

3. Review the following for additional information:

   Automatically start scanning SQL when a job is added	Select this checkbox to start SQL Scanner automatically after you add a scan job.
   Skip SQL within comments	Select this checkbox to ignore SQL statements within comments enclosed by /* */, // and –- in the source code. By default, the scanning algorithm searches for SQL statements contained in comments.
   Skip SQL that does not access any tables	Select this checkbox to ignore SQL statements that do not access tables.
   Whole word matching for the first SQL keyword	Select this checkbox to search for SELECT, INSERT, UPDATE or DELETE as a whole word. When selected, these keywords must be preceded and followed by a space or end of line character. For example, SQL Scanner will not find the word INSERT if it is included in PROCEDUREINSERT.
   Create Scanner Temp Table	Select this checkbox to automatically create a temporary table during scanning when SQL Scanner finds a CREATE TABLE #TEMP or a SELECT INTO #TEMP statement. SQL Scanner automatically drops tables created at the end of the scanning process.
   Include data	Select this checkbox to automatically execute INSERT, DELETE, UPDATE, and SELECT INTO statements that modify temporary tables SQL Scanner created. Note: Selecting this option may increase total scanning time if SQL Scanner has to load a significant amount of data into the temporary table.
   Override previous Scanner Temp Table	Select this checkbox to have SQL Scanner create a new temporary table each time it finds a new CREATE TABLE or SELECT INTO statement. Note: Selecting this option does not override User-Defined temporary tables.
   Override User-Defined Temp Table	Select this checkbox to have SQL Scanner overwrite an existing User-Defined temporary table when it finds a statement to create a table that uses the same name. Note: Selecting this option does not override temporary tables SQL Scanner created.
   Number of characters to skip at the beginning of every line when scanning	Enter the number of characters you want SQL Scanner to skip at the beginning of each line during scanning.
   Skip end of line continuation character	Select the continuation character you want SQL Scanner to skip at the end of each line during scanning.

Related Topics

About Scanning SQL

Scan SQL

About Temporary Tables

Use Temporary Tables in Scan SQL

Manage Plan Guides

To set manage plan guides options

1. Click .

2. Select Optimize SQL | Manage Plan Guides | Options.

3. Review the following for additional information:

   Plan Guide List	Select checkbox to automatically validate each plan guide at start.
   Backup File Prefix	Specify a prefix for SQL Optimizer to use when creating a file name for the output or backup file when exporting, importing, or migrating plan guides.

Manage Plan Guides Options

To set manage plan guides options

1. Click .

2. Select Optimize SQL | Manage Plan Guides | Options.

3. Review the following for additional information:

   Plan Guide List	Select checkbox to automatically validate each plan guide at start.
   Backup File Prefix	Specify a prefix for SQL Optimizer to use when creating a file name for the output or backup file when exporting, importing, or migrating plan guides.