DROP OUTLINE

Syntax

Purpose

To drop a stored outline.

See Also: "CREATE OUTLINE" and Oracle8i Designing and Tuning for Performance for more information on outlines.

Prerequisites

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

Keywords and Parameters

outline

is 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, the optimizer generates a new execution plan without the influence of the outline.

Example

The following statement drops the stored outline called SALARIES.

DROP OUTLINE salaries;