TOAD EXPLAIN PLAN 설정

TOAD EXPLAIN PLAN 설정

1. 실행계획에 사용할 테이블을 생성한다.

CREATE TABLE PLAN_TABLE (
  STATEMENT_ID    VARCHAR2(30),
  TIMESTAMP       DATE,
  REMARKS         VARCHAR2(80),
  OPERATION       VARCHAR2(30),
  OPTIONS         VARCHAR2(30),
  OBJECT_NODE     VARCHAR2(128),
  OBJECT_OWNER    VARCHAR2(30),
  OBJECT_NAME     VARCHAR2(30),
  OBJECT_INSTANCE NUMERIC,
  OBJECT_TYPE     VARCHAR2(30),
  OPTIMIZER       VARCHAR2(255),
  SEARCH_COLUMNS  NUMBER,
  ID              NUMERIC,
  PARENT_ID       NUMERIC,
  POSITION        NUMERIC,
  COST            NUMERIC,
  CARDINALITY     NUMERIC,
  BYTES           NUMERIC,
  OTHER_TAG       VARCHAR2(255),
  PARTITION_START VARCHAR2(255),
  PARTITION_STOP  VARCHAR2(255),
  PARTITION_ID    NUMERIC,
  OTHER           LONG,
  DISTRIBUTION    VARCHAR2(30)
)

 

 

2.   메뉴 - View > Options

 

3.  실행계획 실행 Ctrl + E