IBM Documentation.
DB2ã§ã¯*1ã¢ã¯ã»ã¹ãã¹ã®æ±ºå®ã«*2çµ±è¨æ å ±ã使ç¨ãã¾ãã ãã®ãããçµ±è¨æ å ±ãç¾å¨ã®ãã¼ãã«ã®ç¶æ ã¨ããé¢ãã¦ããã¨ã ãããã¤ã³ããã¯ã¹çãæé©ã«è¨è¨ãã¦ããã¬ã¹ãã³ã¹ãæªããªãã¾ãã ä¾ãã°ããã¼ã¿ã100è¡ç¨åº¦ã®ç¶æ ã§ãã¤ã³ãããã¢ããªã±ã¼ã·ã§ã³ã§ã¯ã ãã¼ã¿éãå°ãªããããDB2ã¯ãã¼ã¿ãã¼ã¹ã¹ãã£ã³ã鏿ããããããã¾ããã (ãã¼ã¿éãå°ãªãå ´åãã¤ã³ããã¯ã¹ãè¦ãã¨èªã¿è¾¼ããã¼ã¸æ°ãå¢ããã®ã§) ãããããã®å¾ãã¼ã¿ãå¢ãç¶ãã¦ãçµ±è¨æ å ±ã®æ´æ°ãã¤ãåãã¤ã³ããããªãã¨ã ãã£ã¨ãã¼ã¿ãã¼ã¹ã¹ãã£ã³ã§ãã®ãã¼ãã«ãæ¤ç´¢ãããã¨ã«ãªãã¾ãã ããã§è¡¨ãã¤ã³ããã¯ã¹ã«*3RUNSTATSãå®è¡ãããã¨ã§ãããã©ã¼ãã³ã¹ãåä¸ãã¾ãã å¤§è¦æ¨¡ãã¼ã¿ãã¼ã¹ç¨å¹æãããã¨æãã¾ãã RUNSTATSã³ãã³ã db2 "RUNSTATS ON TABLE [ã¹ãã¼ãã¼å].[ãã¼ãã«
DB2ã§å®è¡è¨ç»ãåå¾ããæã«ã大å¤ã³ã¹ããé«ããã®ãããã¨ãããã¨ã§ ã¾ãç¬¬ä¸æ®µéã¨ãã¦ã¤ã³ããã¯ã¹ã®ãã¥ã¼ãã³ã°ãããäºã«ãªãã¾ããã æåã¯è©²å½ã®SQLãç®ã§è¿½ã£ã¦ãæªããããªã¨ããã«ã¤ã³ããã¯ã¹ãã¯ã£ã¦ããã®ã§ãã ãã¡ããã¡ãéå¹çã¨è¨ãäºã§ãã¤ã³ãã©ã®DBAã®äººã«ç¸è«ããã¿ãã ï½¢db2advisï½£ã³ãã³ãã¯ã©ãã ãã¼ã¨è¨ããã¨ã§ããã db2advis ã³ã³ããã¼ã«ã»ã³ã¿ã¼ã«ä»å±ãã¦ãããè¨è¨ã¢ããã¤ã¶ã¼ãã®ã³ãã³ãã©ã¤ã³ç 使ãã¹ãã¤ã³ããã¯ã¹ã«ã¤ãã¦ã¢ããã¤ã¹ãåå¾ãã ä½¿ç¨æ¹æ³ db2advis -d ãã¼ã¿ãã¼ã¹å -n ã¹ãã¼ãå -i SQLãã¡ã¤ã«å åèã«ããã¦é ããã®ã¯ãã¡ãã®ãµã¤ã Unofficial DB2 BLOG 使ãã¹ãã¤ã³ããã¯ã¹ã«ã¤ãã¦ã¢ããã¤ã¹ãåå¾ããã«ã¯ ãã¥ã¼ãã³ã°æé 1 å®è¡è¨ç»ã®åå¾ å¥ã®ã¨ã³ããªã§ç´¹ä»ããA5:SQL Mk
ã¢ã¯ã»ã¹ã»ãã©ã³ã®Explain SQL Explainæ©è½ã¯SQLã³ã³ãã¤ã©ã®æ©è½ã®ä¸é¨ã§ãããã¹ãã¼ãã¡ã³ãã®ã¢ã¯ã»ã¹ã»ãã©ã³ãããã³ã¹ãã¼ãã¡ã³ããã³ã³ãã¤ã«ãããç°å¢ã表示ããããã«ä½¿ããã¾ããExplainã®æ å ±ã¯ãããã¤ãã®æ¹æ³ã§åéããã³è¡¨ç¤ºãããã¨ãã§ãã¾ãã Explainã®æ å ±ã¯ã以ä¸ãè¡ãããã«å½¹ç«ã¡ã¾ãã ç §ä¼ã®ããã«é¸æãããå®è¡ãã©ã³ãçè§£ãã ã¢ããªã±ã¼ã·ã§ã³ã»ããã°ã©ã ãè¨è¨ãã ã¢ããªã±ã¼ã·ã§ã³ããã¤åãã¤ã³ããã¹ãããæ±ºå®ãã ãã¼ã¿ãã¼ã¹ãè¨è¨ãã SQLã¹ãã¼ãã¡ã³ãã®Explainãã¼ã¿ãåå¾ããã«ã¯ãExplainæ©è½ãå¼ã³åºã許å¯IDã¨åãã¹ãã¼ãã使ç¨ãã¦ãäºåã«Explain表ãå®ç¾©ãã¦ããå¿ è¦ãããã¾ããExplain表ã®DDLã«ã¤ãã¦ã¯ãDB2ã®ã¤ã³ã¹ãã¼ã«ã»ãã£ã¬ã¯ããªã®ãsqllib/misc/explain.ddlãã¾ãã¯ãsql
SQLã®ã¢ã¯ã»ã¹ã»ãã©ã³ã確èªããæé ã®ã¡ã¢ã§ããã¡ãã£ã¨ããã£ã¦ã¿ãã ãã®ç°¡åãªã¡ã¢ãªã®ã§è©³ããã¯ä»¥ä¸ãåç §ã DB2 ãªãã¡ã¬ã³ã¹ - SQL Explain æ©è½ @IT SQLãåæããé«åº¦ãªãã¯ãã㯠DB2éå¼ããªãã¡ã¬ã³ã¹ - EXPLAIN表ã使ããã«ã¯ æ¦è¦ EXPLAIN表ã使ãã ãexplain all for ãã¨ããSQLæãå®è¡ããã ãdb2exfmtãã³ãã³ãã使ã£ã¦ã¢ã¯ã»ã¹ãã©ã³ãåºåããã 1.EXPLAIN表ã使ãã 以ä¸ã®ã³ãã³ããå®è¡ãã¦EXPLAIN表ã使ãã¾ãã $ db2 -tvf <DB2ã®ã¤ã³ã¹ãã¼ã«ãã£ã¬ã¯ã㪠ä¾) /opt/ibm/db2/V9.1 >/misc/EXPLAIN.DDL 2.ãexplain all for ãã¨ããSQLæãå®è¡ããã 調æ»ãããSQLãæå®ãã¦ãexplain all forããå®è¡ãã¾
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}