DROP OUTLINE

Function

Deletes an outline.

Precautions

A bound outline cannot be deleted.
Only the database administrator has the permission to execute this command.

Syntax

     
          DROP OUTLINE outline_name FOR sql_hash;

Parameter Description

**Table 1** DROP OUTLINE parameters
Parameter	Description	Value Range
outline_name	Specifies the name of the outline you want to delete.	-
sql_hash	Delete the outline corresponding to sql_hash.	-

Examples

Delete an unbound outline.

     
          DROP OUTLINE outline_test3 FOR sql_be2995e824abb8b712b69fca4825b532;

Delete a bound outline. An error is expected to be reported.

     
          SELECT sql_hash, outline_name FROM sql_plan_baseline;
               sql_hash               |               outline_name
--------------------------------------+------------------------------------------
 sql_3d937542c0d24c9c995f31cba327fa56 | outline_413ac0e566ff20be320f5ef0774bf1eb
 sql_6e7be6e92878d67d30b602d16b779a99 | outline_62bcfca3d090e777d7a6e6a88a49e53f
(2 rows)

DROP OUTLINE outline_413ac0e566ff20be320f5ef0774bf1eb FOR sql_3d937542c0d24c9c995f31cba327fa56;
ERROR:  The outline(specified by sql_hash[sql_3d937542c0d24c9c995f31cba327fa56] and outline_name[outline_413ac0e566ff20be320f5ef0774bf1eb]) is bind