Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9 - Installation Guide

Abstract Plan Manager Tutorial

The Abstract Plan Manager provides a window for you to easily view, create, delete and modify your abstract plan groups.

In Adaptive Server version 15 and later, the abstract plan enables you to influence the optimization of a SQL statement without having to modify the SQL statement syntax. If you cannot change the source code that contains your SQL statement, you can use the abstract plan to force Adaptive Server to use a specific query plan for a SQL statement. This is particularly useful if you have third party applications where you do not have access to the source code.

Manage Abstract Plans

  1. Click to open the Abstract Plan Manager window.

  2. You can navigate within the Abstract Plan Manager to work with abstract plan groups or individual plans within any database, and all functions within this module are available from the right-click menu.

  3. To create a new abstract plan group, right-click and select Group | Create.

  4. Select under which database you want this group created (or if you want this created in all databases, select the checkbox Create in all databases) and name your abstract plan group.

  5. With already created groups, there are many functions you can employ by right-clicking a group including dropping or purging a plan group, performing an import or export of a plan group, or even comparing plan groups.

  6. Locating an abstract plan can be done at any level in the tree structure by selecting Find Abstract Plan | Text, or ID.

  7. Individually plans can be manipulated by drilling down to a specific Plan ID and specifying whether you would like to drop, copy, or edit an individual abstract plan.

 

Related Topic

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating