立即与支持人员聊天
与支持团队交流

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

Review Plans

Use the Plans pane to review the SQL text and execution plan for the plans SQL Optimizer generates. You can also review the run time statistics for your original SQL statement and the plans after you execute the plan alternatives.

To review details for a plan

  1. Select the Optimize SQL tab in the main window.
  2. Select a Plan Control session.
  3. Select an execution plan alternative in the Plans pane.
  4. Review the details of the alternative plan in the Execution Plan pane.

    Note: You must execute the alternative plans before you can review run time statistics. See Test Run Execution Plan Alternatives for more information.

  

Related Topics

View Execution Statistics (Plan Control)

Compare Execution Plan Alternatives

Original SQL Text

The text editor is used to display the SQL text of the selected plan guide. It can be edited when there is only an original plan. When the plan is user defined, you can change the plan by clicking the hyperlink to add query hints and table hints.

 

Related Topics

View SQL Information (Plan Control)

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

To view SQL information

  1. Select the Optimize SQL tab in the main window.
  2. Select a Plan Control session.

  3. Select the SQL Information tab in the Optimize SQL window. Click the following to view the information that displays for each pane.

  

Related Topics  

About Optimizing SQL (Plan Control)

View Schema Information

View Execution Statistics (Plan Control)

View Execution Statistics (Plan Control)

You can view execution statistics in the Plans pane or in the Execution Statistics tab.

To view execution statistics in the Plans pane

  • To sort alternatives by an execution statistic, click a column header in the Plans grid.
  • To change the Optimization Goal, click the Execution Elapsed Time column header and select another goal from the drop-down list.

To view execution statistics

  1. Select the Optimize SQL tab in the main window.
  2. Select Plan Control from the Optimize SQL start page.

  3. Select the Execution Statistics tab in the Plan Control window.
  4. Review the following for additional information:

    Statistics Name Description
    Execution Time Shows CPU time and elapsed time required to execute the SQL statement after SQL Optimizer complies it.
    Compile Time Shows CPU time and elapsed time required to compile the SQL statement.
    IO Statistics

    Shows run time scan count, logical reads, physical reads, and read-ahead reads information recorded during execution of the SQL statement.

    Also displays information for each table used during execution.

    Note: This information is only available after you execute the SQL statement.

  

Related Topics 

View SQL Information (Optimizer)

View Schema Information

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级