문서의 선택한 두 판 사이의 차이를 보여줍니다.
양쪽 이전 판 이전 판 다음 판 | 이전 판 마지막 판 양쪽 다음 판 | ||
notepad:mulling [2010/10/04 20:13] mulling 삭제 |
notepad:mulling [2010/10/05 19:35] mulling 옛 버전 복구 |
||
---|---|---|---|
줄 4: | 줄 4: | ||
- **중요한내용은 이렇게? | - **중요한내용은 이렇게? | ||
- | -<del> | + | <code :sql> |
- | a2dev01: | + | --------------------------------------------------------------------------------------------------------------------------------------------------- |
- | + | 1.to_date 함수 안씌우고 date 비교 ex) 컬럼 >= '2010-07-01' | |
- | DB2 Universal Database Version 9.7, 5622-044 © Copyright IBM Corp. 1991, 2008 Licensed Material | + | |
- | + | ||
- | DB2 Universal Database Version 9.7, 5622-044 © Copyright IBM Corp. 1991, 2008 Licensed Material | + | |
- | + | ||
- | DYNAMIC *** | + | |
- | + | ||
- | STATEMENT | + | |
- | Isolation Level | + | |
- | Blocking | + | |
- | Query Optimization Class = 5 Partition Parallel | + | |
- | Intra-Partition Parallel = No SQL Path = " | + | |
- | " | + | |
select * | select * | ||
from DB2INSTL.DW_XXXXXX | from DB2INSTL.DW_XXXXXX | ||
- | where ENDTIME >=TO_DATE('2010-06-01 00:00:00', ' | + | where ENDTIME > |
- | HH24: | + | |
- | ' | + | |
- | + | ||
- | 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: | + | |
- | + | ||
- | | + | |
- | " | + | |
- | " | + | |
- | " | + | |
- | FROM " | + | |
- | WHERE (TO_TIMESTAMP(: | + | |
- | | + | |
- | + | ||
- | 1: DB2INSTL.DW_XXXXXX | + | |
- | Base = ORADWADM.DW_XXXXXX #Input Columns = 2 #Output Columns = 10 | + | |
- | End of section | + | SELECT * |
+ | FROM " | ||
+ | WHERE (TO_TIMESTAMP(' | ||
+ | AND (A0." | ||
- | Optimizer Plan: | + | 2.DDL |
+ | << Oracle >> | ||
+ | CREATE TABLE ORADWADM.DW_XXXXXX | ||
+ | ( | ||
+ | PRTNAME | ||
+ | LTNAME | ||
+ | PRTIONTYPE | ||
+ | PROCESSOPNAME | ||
+ | MNAME | ||
+ | MTYPE | ||
+ | STARTTIME | ||
+ | ENDTIME | ||
+ | ITEMNAME | ||
+ | TIME NUMBER | ||
+ | ) | ||
+ | TABLESPACE TS_DAT | ||
+ | PARTITION BY RANGE (ENDTIME) | ||
+ | ( | ||
+ | PARTITION PT_XXXXXX_0801 VALUES LESS THAN (TO_DATE(' | ||
+ | PARTITION PT_XXXXXX_0802 VALUES LESS THAN (TO_DATE(' | ||
+ | ... | ||
+ | PARTITION PT_XXXXXX_1101 VALUES LESS THAN (TO_DATE(' | ||
+ | ) | ||
- | | + | << DB2 >> |
- | Operator | + | CREATE TABLE " |
- | | + | ( |
- | Cost | + | " |
- | | + | " |
- | 31338.3 | + | " |
- | n/a | + | " |
- | | + | |
- | ( 1) | + | " |
- | 410345 | + | |
- | | | + | " |
- | 31338.3 | + | " |
- | n/a | + | " |
- | | + | ) |
- | ( 2) | + | COMPRESS YES |
- | 410345 | + | DISTRIBUTE BY HASH(" |
- | / | + | PARTITION BY RANGE(" |
- | 4.80221e+08 | + | ( |
+ | PART " | ||
+ | PART " | ||
+ | ... | ||
+ | PART " | ||
+ | ); | ||
- | < | + | 3.오라클 호환모드 |
- | </del> | + | => 현재 설정되어 있지 않음!! |
+ | --------------------------------------------------------------------------------------------------------------------------------------------------- | ||
+ | </code> |