adminschool.net wiki

문서의 이전 판입니다!

---

- 삭제예정은 이렇게 표시

- 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>