DROP OUTLINE

Purpose

Use the DROP OUTLINE statement to drop a stored outline.

See Also:

CREATE OUTLINE for information on creating an outline
Oracle Database Performance Tuning Guide for more information on outlines in general

Prerequisites

To drop an outline, you must have the DROP ANY OUTLINE system privilege.

Syntax

drop_outline::=

Description of the illustration drop_outline.gif

Semantics

outline

Specify the name of the outline to be dropped.

After the outline is dropped, if the SQL statement for which the stored outline was created is compiled, then the optimizer generates a new execution plan without the influence of the outline.

Example

Dropping an Outline: Example The following statement drops the stored outline called salaries.

DROP OUTLINE salaries;