Reassign By Category

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

This action lets you reassign the category of stored outlines in Oracle.

Outlines are a set of results for the execution plan generation of a particular SQL statement. When you create an outline, plan stability examines the optimization results using the same data used to generate the execution plan. That is, Oracle uses the input to the execution plan to generate an outline, and not the execution plan itself.

Platform Availability

To Reassign a Stored Outline to a Different Category

  1. Initiate a Reassign By Category action against one or more stored outlines. For more information see Initiating an object operation.
  2. Use the following table as a guide to understanding and modifying settings in the Reassign By Category wizard:
Step Settings and tasks

Action options

Displays the outlines you selected. Select a new category for the outline or outlines from the Category dropdown.


Preview the DDL generated for the operation. For more information, see Preview.

3. Click Execute. For information on the scheduling option, see Scheduling.