지금 지원 담당자와 채팅
지원 담당자와 채팅

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

Create Manage Plan Guides Session

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

To create a new session

  1. Select the Manage Plan Guides tab in the main window.

  2. Click . The Create Manage Plan Session Guide window displays.

    Note: You can also click to create a new session.

  3. Review the following for additional information:

    Select Connection Description

    Connection

    Click to select a previously created connection.

    Tip: Click to open the Connection Manager to create a new connection. See Connect to SQL Server for more information.

    Select Database Description

    Database

    Click to select the database to match your SQL statement.

Note: You cannot change the database connection for a Manage Plans session. You must create a new session to use a different connection.

  

Related Topics

Manage Plan Guides

Plan Guides Management displays SQL Server plan guides deployed from Plan Control mode in Optimize SQL.

To manage a plan guide

  1. Select the Manage Plan Guides tab in the main window.

    Note: You need to create a new Manage Plans session before managing your stored plan guides. See Create Manage Plan Guides Session for more information.

  2. Select a plan guide deployed from the Optimize SQL module in the Plan Guides pane.

    Tip: Click or if you do not see a plan guide that you deployed from Optimize SQL.

  3. Select the checkbox in the Enabled column to enable the plan guide.

Toolbar Functions

Button/Function Description
Enable plan guides.
Disable plan guides.
Validate the plan guide.
Drop the plan guide.
Refresh the plan guide.
Display the filter panel.
Migrate a plan guide.
Import a plan guide.
Export a plan guide.

To export a plan guide

  1. Select the Manage Plan Guides from the main window.
  2. Select a plan guide in the Plan Guides pane.

    Tip: Press CTRL to select multiple plan guides when clicking a plan guide.

  3. Select .
  4. Select a file name and location for your export file.

To import a plan guide

  1. Select .

  2. Select a file to import.

  3. Review the following for additional information:

    Existing Plan Guides

    Select on of the following when there is a plan guide with identical SQL script found:

    • Skip the new plan guide.
    • Replace the existing plan guide.
    Backup for Target Database Backup the existing plan guides before importing and specify the backup file name and folder path.

To migrate a plan guide

  1. Select .

  2. Click in the Target Connection field and select a connection.

    Tip: Click to create a new connection.

  3. Click in the Target Database field and select a database for your plan guides.

  4. Review the following for additional information:

    Existing Plan Guides

    Select on of the following when there is a plan guide with identical SQL script found:

    • Skip the new plan guide.
    • Replace the existing plan guide.
    Backup for Target Database Backup the existing plan guides before importing and specify the backup file name and folder path.

Tip: To specify a default name for the output or backup file when exporting or migrating plan guides, go to Options | Manage Plan Guides.

  

Related Topics  

Export, Import, and Migrate Plan Guides

Send to SQL Optimizer

 

Filter Columns

To filter a column

» Click to the right of the column header and select a filtering option.

Note: When filtering is applied to columns, displays to the right of the column header. A Filter panel also displays at the bottom of the grid that describes applied filters as illustrated in the following:

Tips:

  • Click in the Filter panel to clear a filter or right-click a filtered column and select Clear Filter.

  • Click in the Filter panel to enable or disable a filter.

  • Click in the Filter panel to select a previously defined filter.

 

Export, Import, and Migrate Plan Guides

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

To export a plan guide

  1. Select the Manage Plan Guides from the main window.
  2. Select a plan guide in the Plan Guides pane.

    Tip: Press CTRL to select multiple plan guides when clicking a plan guide.

  3. Select .
  4. Select a file name and location for your export file.

To import a plan guide

  1. Select .

  2. Select a file to import.

  3. Review the following for additional information:

    Existing Plan Guides

    Select on of the following when there is a plan guide with identical SQL script found:

    • Skip the new plan guide.
    • Replace the existing plan guide.
    Backup for Target Database Backup the existing plan guides before importing and specify the backup file name and folder path.

To migrate a plan guide

  1. Select .

  2. Click in the Target Connection field and select a connection.

    Tip: Click to create a new connection.

  3. Click in the Target Database field and select a database for your plan guides.

  4. Review the following for additional information:

    Existing Plan Guides

    Select on of the following when there is a plan guide with identical SQL script found:

    • Skip the new plan guide.
    • Replace the existing plan guide.
    Backup for Target Database Backup the existing plan guides before importing and specify the backup file name and folder path.

  

Related Topics  

관련 문서

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택