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

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 (SQL Rewrite)

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 a SQL Rewrite session.
  3. Select the Schema Information tab in the Optimize SQL window.

    Tip: Click to retrieve all schema objects.

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

    Tips:  

    • Click to reorganize indexes..

    • Click to analyze the selected table.

  

Related Topics  

View SQL Information (SQL Rewrite)

View Execution Statistics (SQL Rewrite)

View Cursor Settings and Bind Variables (SQL Rewrite)

To view cursor settings and bind variables

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

  3. Review the following for additional information:

  • The Cursor Type and associated Cursor Argument configured in the cursor settings window are displayed in the top pane. See Optimize SQL Used in Cursors for more 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 (SQL Rewrite)

View Schema Information (SQL Rewrite)

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.

評価を選択