notepad:mulling

차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

차이 보기로 링크

--- notepad:mulling [2010/05/06 02:10]
mulling
+++ notepad:mulling [2010/10/04 20:14]
mulling
@@ 줄 3: / 줄 3: @@
 - SQL은 이렇게~<code :sql> select dummy from dual</code>
 - **중요한내용은 이렇게?**
+- <del>
+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_MACHINETIME_LTPS
+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: AMDW (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_MACHINETIME_LTPS" A0
+   WHERE (TO_TIMESTAMP(:H0 )<=A0."ENDTIME" )AND (A0."ENDTIME" <
+           TO_TIMESTAMP(:H1 ))Nicknames Referenced:
+: DB2INSTL.DW_MACHINETIME_LTPS  ID = 65533,32775
+    Base = ORADWADM.DW_MACHINETIME_LTPS#Input Columns = 2 #Output Columns = 10
+End of section
+Optimizer Plan:
+             Rows
+           Operator
+             (ID)
+             Cost
+.3
+             n/a
+           RETURN
+            ( 1)
+
+             |
+.3
+             n/a
+            SHIP
+            ( 2)
+
+          /       \
+.80221e+08     4.84698e+08  Index: n/a <65533,32775,1> Nickname:
+                <65533,32775>
+</del>

notepad/mulling.txt · 마지막으로 수정됨: 2010/10/06 14:39 저자 mulling