문서의 이전 판입니다!
- 삭제예정은 이렇게 표시
- SQL은 이렇게~
SELECT dummy FROM dual
- 중요한내용은 이렇게?
-
a2dev01:db2instl:/db2/db2instl>db2expln -d amedb01 -f 1 -t -g -z ';'
DB2 Universal Database Version 9.7, 5622-044 © Copyright IBM Corp. 1991, 2008 Licensed Material - Program Property of IBM IBM DB2 Universal Database SQL and XQUERY Explain Tool
DB2 Universal Database Version 9.7, 5622-044 © Copyright IBM Corp. 1991, 2008 Licensed Material - Program Property of IBM IBM DB2 Universal Database SQL and XQUERY Explain Tool
DYNAMIC ***
STATEMENT
Isolation Level = Cursor Stability
Blocking = Block Unambiguous Cursors
Query Optimization Class = 5 Partition Parallel = No
Intra-Partition Parallel = No SQL Path = “SYSIBM”, “SYSFUN”, “SYSPROC”, “SYSIBMADM”,
“DB2INSTL”Statement:
select *
from DB2INSTL.DW_XXXXXX
where ENDTIME >=TO_DATE('2010-06-01 00:00:00', 'YYYY-MM-DD
HH24:MI:SS')and ENDTIME < TO_DATE('2010-07-01 00:00:00',
'YYYY-MM-DD HH24:MI:SS')Section Code Page = 1208
Estimated Cost = 410345.156250 Estimated Cardinality = 31338.298828
Ship Federated Subquery #1
Return Data to Application
Federated Substatement #1: Server: ORACLE(ORACLE 10g) SQL Statement:
SELECT A0.“ENDTIME” , A0.“PRODUCTNAME” , A0.“LOTNAME” , A0.
“PRODUCTIONTYPE” , A0.“PROCESSOPERATIONNAME” , A0.
“MACHINENAME” , A0.“MACHINETYPE” , A0.“STARTTIME” , A0.
“ITEMNAME” , A0.“TIME”
FROM “ORADWADM” .“DW_XXXXXX” A0
WHERE (TO_TIMESTAMP(:H0 )⇐A0.“ENDTIME” )AND (A0.“ENDTIME” <
TO_TIMESTAMP(:H1 ))Nicknames Referenced:
1: DB2INSTL.DW_XXXXXX ID = 65533,32775
Base = ORADWADM.DW_XXXXXX #Input Columns = 2 #Output Columns = 10
End of section
Optimizer Plan:
Rows
Operator
(ID)
Cost
31338.3
n/a
RETURN
( 1)
410345
|
31338.3
n/a
SHIP
( 2)
410345
/ \
4.80221e+08 4.84698e+08 Index: n/a <65533,32775,1> Nickname:
<65533,32775>