검색결과 리스트
실행계획에 해당되는 글 1건
- 2007.12.10 TOAD 실행계획 테이블 생성 및 사용법
글
TOAD 실행계획 테이블 생성 및 사용법
Database
2007. 12. 10. 12:32
1. 테이블을 생성한다.
create table TOAD_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));
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 -> Oracle -> General
가운데 Explain Plan부분에서
Schema는 오라클 로그인계정
table은 위에 생성한 테이블명 입력
Ok!
3. 실행대상 sql구문에 Control+E 키를 누르면 Plan이 제시됨.
