1.ç±äºå¯ä¸ç´¢å¼æ«ææçæé«ï¼å æ¤è½ä½¿ç¨å¯ä¸ç´¢å¼ï¼å°½é使ç¨å¯ä¸ç´¢å¼ï¼
2.对äºåå¼åºæ°è¾å°çå段ï¼å¦æ§å«ãç¶æãCheck项ï¼å°½é使ç¨ä½å¾ç´¢å¼ï¼
3.ç±äºNULLå¼å¨ç´¢å¼ä¸æ²¡æå®ä¹ï¼å æ¤å»ºè®®å°½éä¸è¦å¨å
许NULLå¼çåä¸å»ºç«ç´¢å¼ï¼è½ç¶Oracle宣称å¨å
许NULLå¼çåä¸ä½å¾ç´¢å¼ï¼ä¹æ¯ææçï¼ä½æ们ä¾ç¶å¼ºç建议å¯ä»¥å°nullæå®ä¸ºä¸ä¸ªé»è®¤çå¼åå建ç«ç´¢å¼ï¼
4.æ ¹æ®å®é
æ
åµï¼ä¸è¬å¯¹äºåä¸è¶
è¿10个ï¼æ°æ®ä¸è¶
è¿1ä¸è¡ç表ä¸è¦å»ºç«ç´¢å¼ï¼æ¤ç§æ
åµå¨åºç¨ä¸å¾å¾è½å 40%以ä¸ï¼
5.ä¸ä¸ªè¡¨ä¸ä¸æ¯å»ºç«çç´¢å¼è¶å¤è¶å¥½ï¼ç¸åè¿å¤çç´¢å¼å¯è½å½±åæ´ä½çæ§è½ï¼è³å°å½±åINSERTãDELETEåUPDATEçæ§è½ï¼
6.对äºæ¥è¯¢ä¸çWHEREåå¥ç»å¸¸éè¦ä½¿ç¨å¤ä¸ªANDæ¡ä»¶ä¸èµ·ä½¿ç¨æ¶ï¼åºå»ºç«èåç´¢å¼ï¼ä¸è¬æ
åµä¸ï¼æ¤ç§èåç´¢å¼æ¯æ 示ä¸è¡å¯ä¸è®°å½çï¼è主é®ä½¿ç¨ä»£ç主é®ï¼å¹¶ä¸å°½éå°å¼å°çåæ¾å¨åé¢ï¼
7.对äºå¤è¡¨èåæ¥è¯¢ï¼å表è¿æ¥çé®é¢ï¼å¯¹äºè¿æ¥çå段ï¼éè¦å»ºç«ç´¢å¼ï¼
8.平衡索å¼ä¸æ´æ°çå
³ç³»ãå¦æä¸ä¸ªå¤§è¡¨çæ´æ°æä½å¤äºæ¥è¯¢æä½ï¼å»ºè®®å¯ä»¥å°å»ºç«ç´¢å¼ï¼å¦æä¸ä¸ªå¤§è¡¨çæ¥è¯¢æä½å¤äºæ´æ°æä½åå¯ä»¥èèå¤ä½¿ç¨ç´¢å¼ã
ç´¢å¼ä¹æ§è½ä½éªåçæµæ¡ä¾
1.Oracle Explain Planç»æä¸å 个éè¦å次解é
ï¼1ï¼COSTï¼
Oracleä¾æ®å
¶æ¥è¯¢ä¼åå¨éæ©çæ§è¡è·¯å¾ä¼°ç®çæä½å¼éï¼ä¹ç§°ä¸ºææ¬ãèè´¹ï¼ãå¼é并ä¸å³å®è¡¨ç访é®æä½ï¼å
¶å¼ä¸å
·å¤ä»»ä½ç¹å®ç度éåä½ï¼ä»
ä»
代表该
æ§è¡è®¡åçå æå¼ï¼æ¯éè¿IO_COSTåCPU_COST计ç®å¾åºç(oracleææ¡£ä¸æªå
¬å¸ç®æ³ï¼ã
ï¼2ï¼CPU_COSTï¼ æ¥è¯¢ä¼åå¨éè¦çCPUæä½å¼éä¼°ç®å¼ï¼å
¶å¼ä¸æä½æéçæºå¨è¿è½¬å¨æææ£æ¯ã
ï¼3ï¼IO_COSTï¼æ¥è¯¢ä¼åå¨éè¦çIOæä½å¼éä¼°ç®å¼ï¼å
¶å¼ä¸è¯»åçæ°æ®åææ£æ¯ã
1.Oracle Explain Planç»æä¸å 个éè¦å次解é
ï¼4ï¼CARDINALITYï¼ æ¥è¯¢ä¼åå¨è®¿é®çæ°æ®è¡çä¼°ç®åºæ°ã
ï¼5ï¼TIMEï¼æ¥è¯¢ä¼åå¨æ¶èçæ¶é´ä¼°ç®å¼ï¼åä½ä¸ºç§ï¼ã
2.å é¤ç´¢å¼
å°è¡¨account_tradeä¸çææç´¢å¼åå é¤æ
3.æ§è½çæµä½éª
使ç¨SQLè¯å¥
3.æ§è½çæµä½éª--使ç¨SQLè¯å¥
lå¼ééä½47%ãæ§è¡æ¶é´æé«31%
læ¤å¤è¿æå¤ç§æ¥çæ¹å¼ï¼SQLçªå£æ¥è¯¢ãPL/SQL DEVELPOER 解é计åçªå£ãéè¿toadæ¥çç
温馨提示:答案为网友推荐,仅供参考