Name
CREATE/ALTER/DROP OUTLINE
Synopsis
CREATE Syntax:
CREATE [{PUBLIC | PRIVATE}] OUTLINE [outline_name]
[FROM [{PUBLIC | PRIVATE}] source_outline]
[FOR CATEGORY category] [ON statement]ALTER Syntax:
ALTER OUTLINE [{PUBLIC | PRIVATE}] outline_name
{ REBUILD
| RENAME TO new_outline_name
| CHANGE CATEGORY TO new_category_name
}DROP Syntax:
DROP OUTLINE outline_nameCreates, modifies, or removes a set of attributes used by the optimizer to generate an execut ion plan. New in Oracle8i.
Keywords
- PUBLIC
Specifies that the outline is available to all users. This is the default. The use of this keyword in the ALTER OUTLINE statement is new with Oracle9i.
- PRIVATE
Specifies that the outline is private to the current session. The use of this keyword in the ALTER OUTLINE statement is new with Oracle9i.
- source_outline
Name of an existing outline from which this outline will be copied.
- category
Name of the category for grouped outlines.
- ON statement
Specifies the SQL statement for which Oracle will create an outline when the statement is compiled. This clause is optional only if you are creating a copy of an existing outline using the FROM clause.
- REBUILD
Specifies that Oracle is to regenerate the execution plan for outline_name using current conditions.
- RENAME TO
Specifies that the outline is to be renamed.
- CHANGE CATEGORY TO
Specifies that this outline will be placed in a new category.