アクセスプランの出力例を示します。
出力レベルに1を指定した場合
###################### ACCESS PLAN START 11:01:05 04/20 ###################### Input SQL statement: SELECT*FROM SCM1.VIEW1 WHERE C1=10 AND C2<>0 AND C3>ALL(SELECT C1 FROM SCM1.T BL2 WHERE VIEW1.C4=TBL2.C2)FOR READ ONLY =============================================================================== Main query =sno===sectname=====input1==============input2==============output/update====== 1 : SCAN [TBL1_IX1_DSO ][ ][SORT0002 ] 2 : SCAN [SORT0002 ][TBL1_BASE_DSO ][WORK0001 ] 3 : SCAN [WORK0001 ][ ][APPL ] =============================================================================== 2-1 Subquery =sno===sectname=====input1==============input2==============output/update====== 1 : SCAN [TBL2_IX1_DSO ][TBL2_BASE_DSO ][ ] ############################### ACCESS PLAN END ###############################
出力レベルに2を指定した場合
###################### ACCESS PLAN START 11:01:05 04/20 ######################
Input SQL statement:
SELECT*FROM SCM1.VIEW1 WHERE C1=10 AND C2<>0 AND C3>ALL(SELECT C1 FROM SCM1.T
BL2 WHERE VIEW1.C4=TBL2.C2)FOR READ ONLY
Convert SQL statement:
SELECT TBL1.C1, TBL1.C2, TBL1.C3, TBL1.C4, TBL1.C5, TBL1.C6, TBL1.C7, TBL1.C8
, TBL1.C9 FROM SCM1.TBL1 WHERE TBL1.C1=? AND TBL1.C2<>? AND TBL1.C3>ALL (SELE
CT TBL2.C1 FROM SCM1.TBL2 WHERE TBL2.C2=TBL1.C4)
===============================================================================
Main query
=sno===sectname=====input1==============input2==============output/update======
1 : SCAN [TBL1_IX1_DSO ][ ][SORT0002 ]
-------------------------------------------------------------------------------
[ 1] SCAN ELEMENT
table name SCM1.TBL1
scan type INDEX KEY SCAN(1)
dso name TBL1_IX1_DSO [PAGE/SH]
condition evaluation Yes
scan record number 100
[ 2] INSERT ELEMENT
table name SORT0002
insert record length 12
-------------------------------------------------------------------------------
2 : SCAN [SORT0002 ][TBL1_BASE_DSO ][WORK0001 ]
-------------------------------------------------------------------------------
[ 1] SCAN ELEMENT
table name SORT0002
scan type TABLE ALL SCAN
condition evaluation No
[ 2] SCAN ELEMENT
table name SCM1.TBL1
scan type TABLE KEY SCAN
dso name TBL1_BASE_DSO [PAGE/SH]
condition evaluation Yes
subquery evaluation -->2-1
scan record number 1
[ 3] INSERT ELEMENT
table name WORK0001
insert record length 262
-------------------------------------------------------------------------------
3 : SCAN [WORK0001 ][ ][APPL ]
-------------------------------------------------------------------------------
[ 1] SCAN ELEMENT
table name WORK0001
scan type TABLE ALL SCAN
condition evaluation No
[ 2] OUTPUT ELEMENT
record length 262
===============================================================================
2-1 Subquery
=sno===sectname=====input1==============input2==============output/update======
1 : SCAN [TBL2_IX1_DSO ][TBL2_BASE_DSO ][ ]
-------------------------------------------------------------------------------
[ 1] SCAN ELEMENT
table name SCM1.TBL2
scan type INDEX TABLE SCAN(1)
dso name TBL2_IX1_DSO [PAGE/SH]
TBL2_BASE_DSO [PAGE/SH]
condition evaluation No
scan record number 5
Execution environment
-------------------------------------------------------------------------------
transaction access mode : READ ONLY
transaction isolation level : READ COMMITTED
R_LOCK : NO
JOIN_RULE : AUTO
JOIN_ORDER : AUTO
SCAN_KEY_ARITHMETIC_RANGE : YES
SCAN_KEY_CAST : YES
TID_SORT : YES
TID_UNION : YES
USQL_LOCK : SH
IGNORE_INDEX : NO
INACTIVE_INDEX_SCAN : YES
SAME_COST_JOIN_ORDER : ORDER
GROUP_COL_COND_MOVE : YES
CHOOSE_TID_UNION : NO
MAX_SCAN_RANGE : 1000
SS_RATE : 0.200000 0.250000 0.500000 0.400000 0.000100
############################### ACCESS PLAN END ###############################