Go to main content
OUTLINE statement to drop a stored outline.
To drop an outline, you must have the
OUTLINE system privilege.
Description of the illustration drop_outline.gif
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.
Dropping an Outline: Example The following statement drops the stored outline called
DROP OUTLINE salaries;