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

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

Fill Missing Execution Plans

When you generate virtual index alternatives, SQL Optimizer retrieves virtual execution plans because the indexes are not physically created on the database. You can retrieve execution plans for index alternatives by creating temporary indexes. SQL Optimizer drops the temporary indexes once it retrieves the execution plans.

To fill a missing execution plan

  1. Click or .
  2. Select an index alternative in the Alternatives pane. The Virtual Plan tab displays by default in the Execution Plan pane.

  3. Click the arrow besides and select Fill Missing Plans. The Execution Plan tab now displays an execution plan.

  

Related Topics

 

Fill Missing Estimated Plans

When you generate virtual index alternatives, SQL Optimizer retrieves virtual execution plans because the indexes are not physically created on the database. You can retrieve execution plans for index alternatives by creating temporary indexes. SQL Optimizer drops the temporary indexes once it retrieves the execution plans.

To fill a missing estimated plan

  1. Click or .
  2. Select an index alternative in the Alternatives pane. The Virtual Plan tab displays by default in the Execution Plan pane.

  3. Click and select Fill Missing Estimated Plans. The Execution Plan tab now displays an estimated plan.

  

Related

Get Execution Plans

Copy Execution Plans

To copy an execution plan

» Right-click the execution plan and select Copy.

Note: You can paste execution plans displayed as a Tree Plan or Plain Language Plan in text or bitmap format. Applications such as Microsoft Word allow you to choose the format using the Paste Special option. You can use text applications such as Notepad to paste execution plans in text format or graphic applications such as MS Paint to paste execution plans in bitmap format.

 

Related Topics

Fill Missing Execution Plans

 

Animate Execution Plans

You can animate each step in the execution plan in the order SQL Optimizer executes them.

To animate the execution plan or cancel the animation

» Right-click the execution plan and select Animate Plan Steps.

 

Related Topics

Copy Execution Plans

Fill Missing Execution Plans

 

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级