�V鑛�t�B�B�E�k�B�V�E�\�E���B�V�E�P�B�B�E�F�E薀�b�E�
�j睛�j�B�BEXPLAN PLAN �E�E�E�J�E�m�A�q�A茲襯�u�E�b�E�T�E�P�E���E�P�A�z�N�B�Z��
�G�g�J���B�BOS�B�BWindows NT 4.0
�B�B�B�B�B�B�B�BOracle Oracle8 server
�Z���R���B�BORACLE �E�`�E紂�V�E�q�E�[ �E�J�E�q�E絅�u�E襪�q�I���R���A�I�A譴�j�A�A�A�J�A�P

-- �G���qﾚｺｰﾄﾞ�A���c�N�R�K�A�P�A訃豺隋�u�L覯�t�A���N�H�A�q�A�b�A�A�A�z�A�kSTATEMENT_ID�A���B�V�A�qDELETE�n�N�A�b�P���A�L�A�J�A�P
DELETE FROM PLAN_TABLE WHERE STATEMENT_ID = 'SIC';

-- �q�}ﾃｰﾌﾞﾙ�A�j�R鄒���A�L�A�J�A�P

DROP table PLAN_TABLE; 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            NUMBER(38)       ,OBJECT_TYPE                VARCHAR2(30)       ,OPTIMIZER                  VARCHAR2(255)       ,SEARCH_COLUMNS             NUMBER(38)       ,ID                         NUMBER(38)       ,PARENT_ID                  NUMBER(38)       ,POSITION                   NUMBER(38)       ,COST                       NUMBER(38)       ,CARDINALITY                NUMBER(38)       ,BYTES                      NUMBER(38)       ,OTHER_TAG                  VARCHAR2(255)       ,OTHER                      LONG       ) PCTFREE  15 TABLESPACE TY2 STORAGE  (           INITIAL 20000            NEXT    20000            PCTINCREASE  0          );

/*
|| =================================================================
|| == OPTIMIZERﾓｰﾄﾞ�n���P�P
|| =================================================================
*/

-- ALTER SESSION SET OPTIMIZER_GOAL = ALL_ROWS;
-- ALTER SESSION SET OPTIMIZER_GOAL = FIRST_ROWS;
-- ALTER SESSION SET OPTIMIZER_GOAL = RULE;
-- ALTER SESSION SET OPTIMIZER_GOAL = CHOOSE;

/*
|| =================================================================
|| == EXPLAIN PLAN�A�z�V�c�P��
|| =================================================================
*/
 

EXPLAIN PLAN
SET STATEMENT_ID ='SIC'
FOR
Select Count(*)                                     >
From   T_TEST                                       >  �N�B�Z���A�P�A�SQL�n�N
Where  DETA_SU > 0                                  >
;                                                   >

/*
|| =================================================================
|| == EXPLAIN PLAN �A�z�L覯�t�X�~�z�}
|| =================================================================
*/

SELECT DECODE(ID,0,'',LPAD(' ',3*(LEVEL - 1)) || '.' || POSITION) || ' '||
       OPERATION || ' ' || OPTIONS || ' ' || OBJECT_NAME || ' ' || OBJECT_TYPE ||
       ' ' || DECODE(ID,0,'Cost = ' || POSITION ) QUERY_PLAN
  FROM PLAN_TABLE
 CONNECT BY PRIOR ID = PARENT_ID AND STATEMENT_ID = UPPER('SIC')
 START WITH ID = 0 AND STATEMENT_ID = UPPER('SIC');