문서의 선택한 두 판 사이의 차이를 보여줍니다.
양쪽 이전 판 이전 판 다음 판 | 이전 판 다음 판 양쪽 다음 판 | ||
notepad:mulling [2010/10/04 18:58] mulling 옛 버전 복구 |
notepad:mulling [2010/10/04 20:14] mulling |
||
---|---|---|---|
줄 4: | 줄 4: | ||
- **중요한내용은 이렇게? | - **중요한내용은 이렇게? | ||
- | <code :sql> | + | - <del> |
- | </code> | + | a2dev01:db2instl:/ |
+ | |||
+ | 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 | ||
+ | Query Optimization Class = 5 Partition Parallel | ||
+ | Intra-Partition Parallel = No SQL Path = " | ||
+ | " | ||
+ | |||
+ | select * | ||
+ | from DB2INSTL.DW_MACHINETIME_LTPS | ||
+ | where ENDTIME > | ||
+ | HH24: | ||
+ | ' | ||
+ | |||
+ | Estimated Cost = 410345.156250 Estimated Cardinality = 31338.298828 | ||
+ | |||
+ | Ship Federated Subquery #1 | ||
+ | |||
+ | |||
+ | |||
+ | Return Data to Application | ||
+ | |||
+ | |||
+ | |||
+ | Federated Substatement #1: Server: AMDW (ORACLE 10g) SQL Statement: | ||
+ | |||
+ | | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | FROM " | ||
+ | WHERE (TO_TIMESTAMP(: | ||
+ | | ||
+ | |||
+ | 1: DB2INSTL.DW_MACHINETIME_LTPS | ||
+ | Base = ORADWADM.DW_MACHINETIME_LTPS# | ||
+ | |||
+ | End of section | ||
+ | |||
+ | Optimizer Plan: | ||
+ | |||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | |||
+ | | ||
+ | | ||
+ | | ||
+ | ( 1) | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | SHIP | ||
+ | ( 2) | ||
+ | | ||
+ | / \ | ||
+ | | ||
+ | |||
+ | < | ||
+ | </del> |