문서의 선택한 두 판 사이의 차이를 보여줍니다.
양쪽 이전 판 이전 판 다음 판 | 이전 판 | ||
notepad:mulling [2010/10/04 17:26] mulling |
notepad:mulling [2010/10/06 14:39] (현재) mulling |
||
---|---|---|---|
줄 1: | 줄 1: | ||
- | - < | + | ^ 1장 ^ 2장 ^ 3장 ^ |
+ | | 1행1열 | ||
+ | | 2행1열 | ||
+ | | 3행1열 | ||
+ | | 4행1열 | ||
- | - SQL은 이렇게~< | ||
- | - **중요한내용은 이렇게? | ||
- | <code :sql> | ||
- | a2dev01: | ||
- | |||
- | 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) | ||
- | | ||
- | / \ | ||
- | | ||
- | |||
- | < | ||
- | </ |