OPTIMIZER 의 실행계획 확인하기

EXPLAIN PLAN SET STATEMENT_ID = '임의지정1' FOR
SELECT EMP_ID, EMP_NAME FROM TEMP WHERE EMP_ID > 0;

SELECT LPAD(OPERATION, LENGTH(OPERATION) + 2 * (LEVEL-1))||
DECODE(ID,0,'COST ESTIMATE:'||DECODE(POSITION,'0',
'N/A',POSITION),NULL)||''||OPTIONS||
DECODE(OBJECT_NAME,NULL,NULL,':')||
RPAD(OBJECT_OWNER,LENGTH(OBJECT_NAME)+1,',')||OBJECT_NAME||
DECODE(OBJECT_TYPE,'UNIQUE',' (U) ', 'NIN_UNIQUE',
' (NU) ', NULL)||DECODE(OBJECT_INSTANCE,NULL,NULL,'('||OBJECT_INSTANCE||')')
PLAN FROM PLAN_TABLE
START WITH ID = 0 AND STATEMENT_ID='임의지정1'
CONNECT BY PRIOR ID = PARENT_ID AND STATEMENT_ID='임의지정1';

EXPLAIN PLAN SER STATEMENT_ID = '이름' FOR

SELECT 문

SELECT LPAD ~ START WITH ID = 0 AND STATEMENT_ID='이름' ~

하면 데이터 베이스의 처리 순서(계획)을 볼 수 있음.

Uploaded by Notion2Tistory v1.1.0