Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-02 |
|
|
View PDF |
Use the DROP
OUTLINE
statement to drop a stored outline.
See Also:
|
To drop an outline, you must have the DROP
ANY
OUTLINE
system privilege.
drop_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, the optimizer generates a new execution plan without the influence of the outline.
The following statement drops the stored outline called salaries
.
DROP OUTLINE salaries;