Chat now with support
Chat mit Support

SQL Optimizer for SQL Server 10.1.2 - User Guide

Welcome to SQL Optimizer Optimize SQL
Create Optimize SQL Sessions Open Optimize SQL Sessions Rewrite SQL Plan Control Use Temporary Tables
Optimize Indexes Find SQL Scan SQL Manage Plan Guides Configure Options Tutorials About Us

Scan SQL

This topic may not include a description for every field in the screen or dialog.

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

Scan SQL

About Temporary Tables

Use Temporary Tables in Scan SQL

Scan SQL Options

This topic may not include a description for every field in the screen or dialog.

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

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.

  

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen