notepad:mulling

차이

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

차이 보기로 링크

--- notepad:mulling [2010/10/04 17:34] – mulling
+++ notepad:mulling [2025/10/03 22:30] (현재) – 바깥 편집 127.0.0.1
@@ 줄 1: / 줄 1: @@
-- <del>삭제예정은 이렇게 표시</del>
+^ 1장      ^ 2장        ^ 3장          ^
+| 1행1열    | 1행2열     | 1행3열        |
+| 2행1열    | 교차 (파이프 두개)        ||
+| 3행1열    | 3행2열     | 3행3열        |
+| 4행1열    | 3행2열     | 4행3열        |
-- SQL은 이렇게~<code :sql> select dummy from dual</code>
-- **중요한내용은 이렇게?**
-<code :sql>
-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: 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_XXXXXX" A0
-   WHERE (TO_TIMESTAMP(:H0 )<=A0."ENDTIME" )AND (A0."ENDTIME" <
-           TO_TIMESTAMP(:H1 ))Nicknames Referenced:
-: 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
-.3
-             n/a
-           RETURN
-            ( 1)
-
-             |
-.3
-             n/a
-            SHIP
-            ( 2)
-
-          /       \
-.80221e+08     4.84698e+08  Index: n/a <65533,32775,1> Nickname:
-                <65533,32775>
-</code>

notepad/mulling.1286181248.txt.gz · 마지막으로 수정됨: 2025/10/03 22:30 (바깥 편집)