Toad World Blog

Deploy Outlines

Jan 10, 2013 11:00:00 PM by Steve Hilker

The Deploy Outline function in Optimize SQL improves SQL statement performance without changing your original source code. Using Optimize SQL, you can generate SQL statements that are semantically equivalent to your original SQL statement with alternative execution plans. Once you identify the best alternative for your database environment, you can deploy it as a stored outline to use with your original statement.

To deploy an outline

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

  2. Click the arrow beside TB_CreateSession_OptimizeSQL and select New SQL Rewrite Session.

  3. Enter your original SQL statement in the Alternative Details pane and click TB_AutoOptimize. The Select Connection and Schema window displays.

  4. Select a connection and schema to use.

  5. Right-click the alternative you want to deploy as an outline in the Alternatives pane and select Deploy Outline. The Deploy Outline window displays.

  6. Review the following for additional information:

    Outline name Enter a name for the stored outline
    Category

    Click 4812.TB_DownArrow and select a previously created category or enter a new category name.

    Notes:

    • The default category name is SQL_OPTIMIZIER.
    • You can add the outline to a disabled category until you test the SQL statement with and without using the outline.

     

  7. Click 3173.TB_DeployButton.

Note: You can use the Outline Management feature in Manage Plans to enable and disable categories or to move outlines to different categories.

Tags: Toad for Oracle SQL Optimizer for Oracle Wiki Tutorial

Steve Hilker

Written by Steve Hilker

Steve Hilker was a Product Manager for Quest Software. Steve has over 35 years technical experience spanning application development, system administration, database management and various management positions at several software companies. Steve was the founder of RevealNet, best known for its desktop knowledge bases and unique database tools such as PL/Formatter. RevealNet was acquired by Quest Software in 2001. He's had the pleasure of being the product manager for many of Quest's database tools.

In his private life, Steve enjoys oil painting and living on a small farm in a pre-Civil war manor home in Fredericksburg, Virginia.