DROP OUTLINE

说明

删除outline

语法

drop_outline ::=

drop_outline::=
    DROP OUTLINE outline_name;

参数

outline_name

outline名称

示例

示例1: 创建绑定计划

-- 切换到 SYSDBA 用户
CONNECT sysdba/szoscar55;

-- 清理环境
DROP TABLE T1 CASCADE;
DROP OUTLINE OUT1;

CREATE TABLE T1(A INT);

-- 创建Outline
CREATE OUTLINE OUT1 ON SELECT * FROM T1 MATCH SELECT * FROM T1;


-- 查询系统表
SELECT OUTLINE_NAME,OUTLINE_DATA FROM SYS_OUTLINE;
OUTLINE_NAME(name)      |OUTLINE_DATA(text)      |
------------------------------------------------
OUT1                    |/*+ FULL(@SEL$1 SYSDBA.T|
                        |1@SEL$1) */             |
总数目：1

-- 删除Outline
DROP OUTLINE OUT1;

DROP TABLE T1;