|Oracle® Database SQL Reference
10g Release 2 (10.2)
|PDF · Mobi · ePub|
To drop an outline, you must have the
OUTLINE system privilege.
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.
DROP OUTLINE salaries;