본문 바로가기
OraclE

orange plan 테이블 생성

by 타마마임팩트_쫀 2022. 1. 30.

CREATE TABLE PLAN_TABLE -- 테이블 이름
(
 STATEMENT_ID     VARCHAR2 (30),
 TIMESTAMP DATE,
 REMARKS          VARCHAR2 (80),
 OPERATION        VARCHAR2 (30),
 OPTIONS          VARCHAR2 (255),
 OBJECT_NODE      VARCHAR2 (128),
 OBJECT_OWNER     VARCHAR2 (30),
 OBJECT_NAME      VARCHAR2 (30),
 OBJECT_INSTANCE  NUMBER,
 OBJECT_TYPE      VARCHAR2 (30),
 OPTIMIZER        VARCHAR2 (255),
 SEARCH_COLUMNS   NUMBER,
 ID               NUMBER,
 PARENT_ID        NUMBER,
 POSITION         NUMBER,
 COST             NUMBER,
 CARDINALITY      NUMBER,
 BYTES            NUMBER,
 OTHER_TAG        VARCHAR2 (255),
 PARTITION_START  VARCHAR2 (255),
 PARTITION_STOP   VARCHAR2 (255),
 PARTITION_ID     NUMBER,
 OTHER            LONG,
 DISTRIBUTION     VARCHAR2 (30),
 CPU_COST         NUMBER,
 IO_COST          NUMBER,
 TEMP_SPACE       NUMBER,
 ACCESS_PREDICATES VARCHAR2 (4000),
 FILTER_PREDICATES VARCHAR2 (4000)
);