SQL Optimizer for SQL Server 10.1.2 - User Guide

Show or Hide Column Attributes

To show or hide a column attribute

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

2. Select the Schema Information tab in the Optimize SQL window.

3. Click besides the Summary list and select a table.

4. Right-click the header row of the Column Attributes pane and select Column Chooser.

   Note: The Column Attributes pane is the second pane in the Schema Information tab.

5. Add or remove column attributes by dragging the column names to and from the Customization dialog.

Related Topics  

View Schema Information

Show or Hide Index Attributes

Show or Hide Table Attributes

Compare Execution Plan Alternatives

Use the Compare window to view the SQL text, execution plan, and execution statistics for your original SQL statement and all alternatives SQL Optimizer generated. The Compare window consists of the Alternatives window and the Comparison window. The Alternatives window displays execution statistics and the Comparison window displays SQL statements and execution plans. You can compare your original SQL statement with an alternative SQL Optimizer generated or compare two different alternatives.

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To compare SQL statements

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

2. Click .

3. Select an alternative in the Alternatives window to compare the statement with your original SQL statement.

   Note: The Comparison window displays the SQL text and execution plan for the original SQL statement in both panes by default.

   Tip: The alternative you selected is shown under your original SQL statement in the Alternatives window by default. To unfreeze the alternative selected, right-click the alternative and select Unfreeze Comparing Rows.

4. Click to switch the location of the original SQL statement and selected alternative in the Comparison window.

   Note: Change the location of the original SQL statement to compare two alternative statements. Once you select the first alternative, click and select the second alternative.

5. Click the current layout option in the Comparison Window to change the layout for the statements you are comparing. Review the following for additional information:

   SQL and Plan (Left-Right)	Displays the SQL text and execution plan for the statements you are comparing side by side.
   Plan Only (Left-Right)	Displays the execution plan for the statements you are comparing side by side.
   SQL and Plan (Top-Bottom)	Displays the SQL text and execution plan for the statements you are comparing beneath each other.
   Plan Only (Top-Bottom)	Displays the execution plan for the statements you are comparing beneath each other.
   Tips: Click to maximize the comparison window. Click to restore the comparison window to its original size.

Related Topics 

About SQL Optimization

Optimize SQL Statements

Test Run SQL Alternatives

Generate Optimize SQL Resolution Report

You can generate a resolution report in SQL Optimizer after you optimize your SQL statement and execute the alternatives. The resolution report includes the following:

• Resolution summary

• Original SQL statement

• Optimization Session Information

• Scenario List

• Comparison Graph

• Best Alternative Scenario

To generate an Optimize SQL resolution report

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

2. Click .

3. Click in the Report window to customize the information displayed in the resolution report.

   Tip: You can display execution plans in text mode, grayscale graphic mode, or full color graphic mode.

Related Topics  

About SQL Optimization

Optimize SQL Statements

Test Run SQL Alternatives

Deploy Plan Guides

In a Plan Control session, deploy a plan alternative as a plan guide to the Manage Plan Guides module.

To deploy a plan guide

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

3. Click and select the alternative from the Select a Plan to Deploy list.

   Note: You can also right-click the alternative you want to deploy as a plan guide in the Alternatives pane and select Deploy Plan Guide.

4. Click Next.

5. Select one on the following options depending on the source of the original SQL.

   It is a single SQL	If you select this option, confirm that the SQL is the same as the source SQL in your script.
   It is part of a Transact-SQL batch	If you select this option: Enter the transact-SQL batch in the left pane by selecting a file or pasting the text. In the right pane, confirm that the SQL is the same as the source SQL in your script
   It is embedded in a database object	If you select this option, select the database object containing the SQL.

6. Enter a custom name for the plan guide, if necessary.
7. Click Next.
8. Click .

Related Topics

About Optimizing SQL (Plan Control)

Generate Execution Plan Alternatives

Test Run Execution Plan Alternatives