ÀüÁ¦Á¶°Ç
DB2EXPLAINÀ» »ç¿ëÇÏ¿© DB2°¡ ¿ä¾à Å×À̺íÀ» »ç¿ëÇϰí ÀÖ´ÂÁö È®ÀÎÇϱâ Àü¿¡ ´ÙÀ½À» ¼öÇàÇØ¾ß ÇÕ´Ï´Ù.
ÀýÂ÷
DB2EXPLAINÀ» »ç¿ëÇÏ¿© DB2°¡ ¿ä¾à Å×À̺íÀ» »ç¿ëÇϰí ÀÖ´ÂÁö È®ÀÎÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
db2 -tvf explain.ddl
set current explain mode explain set current refresh age any SELECT SUM(SALES) FROM MDSAMPLE.SALESFACT set current explain mode no SELECT EXPLAIN_TIME, EXPLAIN_LEVEL AS "LEV", QUERYNO, STATEMENT_TEXT FROM EXPLAIN_STATEMENT WHERE STATEMENT_TEXT LIKE '%SALESFACT%' ORDER BY EXPLAIN_TIME
2002-06-30-23.22.12.325002 O 11 SELECT SUM(SALES) FROM MDSAMPLE.SALESFACT 2002-06-30-23.22.12.325002 P 11 SELECT Q3.$C0 FROM (SELECT SUM(Q2.$C0) FROM (SELECT Q1.SALESFACT_SALES FROM DB2INFO.MQT0000000021T01 AS Q1) AS Q2) AS Q3
ÇÑ ¹øÀÇ Äõ¸® ½ÇÇà¿¡ ´ëÇØ µÎ °³ÀÇ ¶óÀÎÀÌ ÀÖ½À´Ï´Ù. OÀ¸·Î Ç¥½ÃµÈ ¶óÀÎÀº DB2·Î Àü¼ÛµÇ´Â ¿ø·¡ÀÇ Äõ¸®ÀÔ´Ï´Ù. P·Î Ç¥½ÃµÈ ¶óÀÎÀº DB2¿¡ ÀÇÇØ ÀçÀÛ¼ºµÈ Äõ¸®ÀÔ´Ï´Ù. ÀÌ ¿¹Á¦ÀÇ ÀçÀÛ¼ºµÈ Äõ¸®¿¡¼ DB2°¡ DB2INFO.MQT0000000021T01 ¿ä¾à Å×ÀÌºí¿¡¼ µ¥ÀÌÅ͸¦ ¼±ÅÃÇÏ´Â °ÍÀ» º¼ ¼ö ÀÖ½À´Ï´Ù.
.