Oracle® Database SQL Language Reference 11g Release 1 (11.1) Part Number B28286-01 |
|
|
View PDF |
Purpose
Note:
Oracle strongly recommends that you use SQL plan management for new applications. SQL plan management creates SQL plan baselines, which offer superior SQL performance stability compared with stored outlines.You can migrate existing stored outlines to SQL plan baselines by using the LOAD_PLANS_FROM_CURSOR_CACHE
or LOAD_PLANS_FROM_SQLSET
procedure of the DBMS_SPM
package. When the migration is complete, you should disable or remove the stored outlines.
See Also: Oracle Database Performance Tuning Guide for more information about SQL plan management and Oracle Database PL/SQL Packages and Types Reference for information about the DBMS_SPM package
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::=
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;