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

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

View Schema Information

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

To view schema information

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

  3. Select the Schema Information tab in the Plan Control window.

    Tip: Click to retrieve all schema objects.

  4. Click beside the Summary list and select a table for additional information.

    Tips:

  • Select a row in the Statistics Summary pane and click for additional information.
  • Click to reorganize indexes.

  

Related Topics 

View SQL Information (Optimizer)

View Execution Statistics

 

 

View Bind Variables

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

To view cursor settings and bind variables

  1. Select the Optimize SQL tab in the main window.
  2. Select the Cursor and Bind Variables tab in the Optimize SQL window.

  3. Review the following for additional information:

  • The parameters for the bind variable defined for your SQL statement are displayed in the bottom pane. See Set Bind Variables for more information.

Note: Information is only displayed in this tab if you used cursor settings or variables for optimization.

  

Related Topics 

View SQL Information (Optimizer)

View Execution Statistics (Plan Control)

View Schema Information

 

 

Show or Hide Table Attributes

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

To show or hide a table attribute

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

  3. Right-click the header row in the Summary Details pane and select Column Chooser.

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

  

Related Topics

Show or Hide Column Attributes

Show or Hide Index Attributes

Show or Hide Index Attributes

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

To show or hide an index 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 Index Attributes pane and select Column Chooser.

    Note: The Index Attributes pane is the first pane in the Schema Information tab.

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

  

Related Topics  

Show or Hide Column Attributes

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级