サポートと今すぐチャット
サポートとのチャット

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

Plan Control

Plan Control uses the Plan Guides Management feature introduced in SQL Server 2005. You can use this feature to optimize execution plans and to deploy plan guides for SQL statements without changing the original source code. This feature is particularly useful for third-party applications where you do not have access to the source code.

The process begins with SQL Optimizer analyzing your original SQL statement to generate execution plan alternatives. SQL Optimizer then applies a set of SQL Server hints to each execution plan alternative to generate additional alternatives. Once SQL Optimizer completes this process, you can execute the alternatives to retrieve run time statistics for each execution plan alternative and compare the alternatives to identify the best one for your database environment. You can then deploy the selected alternative as a plan guide to the Manage Plan Guides module.

  

Related Topics

About Optimizing SQL (Plan Control)

Plan Control uses the Plan Guides Management feature introduced in SQL Server 2005. You can use this feature to optimize execution plans and to deploy plan guides for SQL statements without changing the original source code. This feature is particularly useful for third-party applications where you do not have access to the source code.

The process begins with SQL Optimizer analyzing your original SQL statement to generate execution plan alternatives. SQL Optimizer then applies a set of SQL Server hints to each execution plan alternative to generate additional alternatives. Once SQL Optimizer completes this process, you can execute the alternatives to retrieve run time statistics for each execution plan alternative and compare the alternatives to identify the best one for your database environment. You can then deploy the selected alternative as a plan guide to the Manage Plan Guides module.

  

Related Topics

Select Connection

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

To select a connection

  1. Select the Optimize SQL tab in the main window.
  2. Click

  3. Review the following for additional information:

    Select Connection Description

    Connection

    Click to select a previously created connection.

    Tip: Click to open the Connection Manager to create a new connection. See Connect to SQL Server for more information.

    Select Database and User Description

    Database

    Click to select the database to match your SQL statement.

    Set User

    Click to select your user name.

  

Related Topics  

Generate Execution Plan Alternatives

Plan Control sessions optimize your SQL statement by generating execution plan alternatives for the statement. You can then select an alternative execution plan for your SQL statement and deploy it as a plan guide to improve database performance.

To generate execution plan alternatives

  1. Select the Optimize SQL tab in the main window.

  2. Select Plan Control from the Optimize SQL start page.

    Note: If the start page does not display, click the arrow beside and select New Plan Control Session.

  3. Enter a SQL statement in the Original SQL pane.

  4. Click to retrieve the execution plan for your SQL statement. The Select Connection window displays.
  5. Select a connection. See Select Connection for more information.
  6. Click to generate execution plan alternatives.

    Tip: Click to abort the process.

  7. When the generation process is finished, select a plan alternative in the Plans pane and review the plan in the Execution Plan pane.
  8. You can then test run the generated plan alternatives. See Test Run Execution Plan Alternatives for more information.

To clear the Plan Control window

To clear the results, right-click inside the Original SQL pane and do one of the following:

  • Select Clear Optimization Results | Keep Original Scenario to clear only the results and retain both the original SQL statement and the database connection.
  • Select Clear Optimization Results | Clear Original Scenario to clear the Plan Control window, but retain the database connection.

  

Related Topics

Test Run Execution Plan Alternatives

関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択