|Oracle® Database SQL Reference
10g Release 2 (10.2)
|PDF · Mobi · ePub|
OUTLINE statement to rename a stored outline, reassign it to a different category, or regenerate it by compiling the outline's SQL statement and replacing the old outline data with the outline created under current conditions.
See Also:CREATE OUTLINE and Oracle Database Performance Tuning Guide for more information on outlines
To modify an outline, you must have the
OUTLINE system privilege.
PUBLIC if you want to modify the public version of this outline. This is the default.
PRIVATE if you want to modify an outline that is private to the current session and whose data is stored in the current parsing schema.
Specify the name of the outline to be modified.
REBUILD to regenerate the execution plan for
outline using current conditions.
See Also:"Rebuilding an Outline: Example"
TO clause to specify an outline name to replace
TO clause to specify the name of the category into which the
outline will be moved.
Use this clause to selectively enable or disable this outline. Outlines are enabled by default. The
DISABLE keyword lets you disable one outline without affecting the use of other outlines.
Rebuilding an Outline: Example The following statement regenerates a stored outline called
salaries by compiling the text of the outline and replacing the old outline data with the outline created under current conditions.
ALTER OUTLINE salaries REBUILD;