rem
rem $Header: utlxplan.sql big_dev/0 11-aug-95.14:02:45 achaudhr Exp $ xplainpl.sql
rem
Rem Copyright (c) 1988, 1995, 1996, 1998 by Oracle Corporation
Rem NAME
REM UTLXPLAN.SQL
Rem FUNCTION
Rem NOTES
Rem MODIFIED
Rem mzait 02/19/98 - add distribution method column
Rem ddas 05/17/96 - change search_columns to number
Rem achaudhr 07/23/95 - PTI: Add columns partition_{start, stop, id}
Rem glumpkin 08/25/94 - new optimizer fields
Rem jcohen 11/05/93 - merge changes from branch 1.1.710.1 - 9/24
Rem jcohen 09/24/93 - #163783 add optimizer column
Rem glumpkin 10/25/92 - Renamed from XPLAINPL.SQL
Rem jcohen 05/22/92 - #79645 - set node width to 128 (M_XDBI in gendef)
Rem rlim 04/29/91 - change char to varchar2
Rem Peeler 10/19/88 - Creation
Rem
Rem This is the format for the table that is used by the EXPLAIN PLAN
Rem statement. The explain statement requires the presence of this
Rem table in order to store the descriptions of the row sources.
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));
select b.emp_no, b.emp_nm, a.GRP_CD from a a, b b
where a.emp_no(+) = b.emp_no
and a.emp_no = 'a'
rem $Header: utlxplan.sql big_dev/0 11-aug-95.14:02:45 achaudhr Exp $ xplainpl.sql
rem
Rem Copyright (c) 1988, 1995, 1996, 1998 by Oracle Corporation
Rem NAME
REM UTLXPLAN.SQL
Rem FUNCTION
Rem NOTES
Rem MODIFIED
Rem mzait 02/19/98 - add distribution method column
Rem ddas 05/17/96 - change search_columns to number
Rem achaudhr 07/23/95 - PTI: Add columns partition_{start, stop, id}
Rem glumpkin 08/25/94 - new optimizer fields
Rem jcohen 11/05/93 - merge changes from branch 1.1.710.1 - 9/24
Rem jcohen 09/24/93 - #163783 add optimizer column
Rem glumpkin 10/25/92 - Renamed from XPLAINPL.SQL
Rem jcohen 05/22/92 - #79645 - set node width to 128 (M_XDBI in gendef)
Rem rlim 04/29/91 - change char to varchar2
Rem Peeler 10/19/88 - Creation
Rem
Rem This is the format for the table that is used by the EXPLAIN PLAN
Rem statement. The explain statement requires the presence of this
Rem table in order to store the descriptions of the row sources.
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));
select b.emp_no, b.emp_nm, a.GRP_CD from a a, b b
where a.emp_no(+) = b.emp_no
and a.emp_no = 'a'
댓글 0
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
86 | sql 문 실행명령 | 원우석 | 2004.07.31 | 3500 |
85 | DB2 종료후 다시 시작 | 원우석 | 2004.07.31 | 2660 |
84 | lock 상태 확인 | 원우석 | 2004.07.31 | 4803 |
83 | sybase DB에서 파일로 백업을 받구 그파일을 다시 DB2로 임포트하는방법 | 원우석 | 2004.07.31 | 3748 |
82 | 임포트시 테이블에 데이터를 모두 클리어 할때 | 원우석 | 2004.07.31 | 2793 |
81 | 특정테이블을 백업받을때 | 원우석 | 2004.07.31 | 3093 |
80 | DB를 백업받을때 | 원우석 | 2004.07.31 | 2811 |
79 | 카탈로그 파일 내용보기 | 원우석 | 2004.07.31 | 2988 |
78 | 데이타 모델링(이화식 강의) 부분 목차정리. | 박상현 | 2004.06.22 | 3124 |
» | oracle 8i제공 explan table 생성 script | 박상현 | 2004.05.08 | 2493 |
76 | toad에서 사용가능한 explan_table생성 script | 박상현 | 2004.05.08 | 6381 |
75 | 오라클 DUAL Table처럼 DB2에서 임시 테이블 사용하기 | 원우석 | 2004.01.08 | 4213 |
74 | ORACLE -> MSSQL 시 LPAD 처리 | 운영자 | 2003.10.08 | 4050 |
73 | Unix, Oracle, Pro*C작성 입찰공고 | 운영자 | 2003.06.05 | 4354 |
72 | Unix, Oracle, Pro*C작성 구인구직게시판 | 운영자 | 2003.06.05 | 4729 |
71 | Unix, Oracle, Pro*C작성 자유게시판 | 운영자 | 2003.06.05 | 4595 |
70 | plan table(sql실행계획) 보는 select문 | 운영자 | 2003.01.28 | 3831 |
69 | java에서 array처리 방법 | 운영자 | 2003.01.27 | 6033 |
68 | 효율적인 25가지 SQL작성법 | 운영자 | 2003.01.04 | 2911 |
67 | 중복 data는 처음에만 display 하게 하는 방법 | 운영자 | 2002.11.23 | 2852 |