ä»æ°æ®ç»æè§åº¦
1ãB+æ ç´¢å¼(O(log(n)))ï¼å
³äºB+æ ç´¢å¼ï¼å¯ä»¥åè MySQLç´¢å¼èåçæ°æ®ç»æåç®æ³åç
2ãhashç´¢å¼ï¼
a ä»
ä»
è½æ»¡è¶³"=","IN"å"<=>"æ¥è¯¢ï¼ä¸è½ä½¿ç¨èå´æ¥è¯¢
b å
¶æ£ç´¢æçé常é«ï¼ç´¢å¼çæ£ç´¢å¯ä»¥ä¸æ¬¡å®ä½ï¼ä¸åB-Tree ç´¢å¼éè¦ä»æ ¹èç¹å°æèç¹ï¼æåæè½è®¿é®å°é¡µèç¹è¿æ ·å¤æ¬¡çIO访é®ï¼æ以 Hash ç´¢å¼çæ¥è¯¢æçè¦è¿é«äº B-Tree ç´¢å¼
c åªæMemoryåå¨å¼ææ¾ç¤ºæ¯æhashç´¢å¼
3ãFULLTEXTç´¢å¼ï¼ç°å¨MyISAMåInnoDBå¼æé½æ¯æäºï¼
4ãR-Treeç´¢å¼ï¼ç¨äºå¯¹GISæ°æ®ç±»åå建SPATIALç´¢å¼ï¼
ä»ç©çåå¨è§åº¦
1ãèéç´¢å¼ï¼clustered indexï¼
2ãéèéç´¢å¼ï¼non-clustered indexï¼
ä»é»è¾è§åº¦
1ã主é®ç´¢å¼ï¼ä¸»é®ç´¢å¼æ¯ä¸ç§ç¹æ®çå¯ä¸ç´¢å¼ï¼ä¸å
许æ空å¼
2ãæ®éç´¢å¼æè
ååç´¢å¼
3ãå¤åç´¢å¼ï¼å¤åç´¢å¼ï¼ï¼å¤åç´¢å¼æå¤ä¸ªå段ä¸å建çç´¢å¼ï¼åªæå¨æ¥è¯¢æ¡ä»¶ä¸ä½¿ç¨äºå建索å¼æ¶ç第ä¸ä¸ªå段ï¼ç´¢å¼æä¼è¢«ä½¿ç¨ã使ç¨å¤åç´¢å¼æ¶éµå¾ªæå·¦åç¼éå
4ãå¯ä¸ç´¢å¼æè
éå¯ä¸ç´¢å¼
5ã空é´ç´¢å¼ï¼ç©ºé´ç´¢å¼æ¯å¯¹ç©ºé´æ°æ®ç±»åçå段建ç«çç´¢å¼ï¼MYSQLä¸ç空é´æ°æ®ç±»åæ4ç§ï¼åå«æ¯GEOMETRYãPOINTãLINESTRINGãPOLYGONãMYSQL使ç¨SPATIALå
³é®åè¿è¡æ©å±ï¼ä½¿å¾è½å¤ç¨äºå建æ£è§ç´¢å¼ç±»åçè¯æ³å建空é´ç´¢å¼ãå建空é´ç´¢å¼çåï¼å¿
é¡»å°å
¶å£°æ为NOT NULLï¼ç©ºé´ç´¢å¼åªè½å¨åå¨å¼æ为MYISAMç表ä¸å建
CREATE TABLE table_name[col_name data type]
[unique|fulltext|spatial][index|key][index_name](col_name[length])[asc|desc]
1ãunique|fulltext|spatial为å¯éåæ°ï¼åå«è¡¨ç¤ºå¯ä¸ç´¢å¼ãå
¨æç´¢å¼å空é´ç´¢å¼ï¼
2ãindexåkey为åä¹è¯ï¼ä¸¤è
ä½ç¨ç¸åï¼ç¨æ¥æå®å建索å¼
3ãcol_name为éè¦å建索å¼çå段åï¼è¯¥åå¿
é¡»ä»æ°æ®è¡¨ä¸è¯¥å®ä¹çå¤ä¸ªåä¸éæ©ï¼
4ãindex_nameæå®ç´¢å¼çå称ï¼ä¸ºå¯éåæ°ï¼å¦æä¸æå®ï¼MYSQLé»è®¤col_name为索å¼å¼ï¼
5ãlength为å¯éåæ°ï¼è¡¨ç¤ºç´¢å¼çé¿åº¦ï¼åªæå符串类åçå段æè½æå®ç´¢å¼é¿åº¦ï¼
6ãascædescæå®ååºæéåºçç´¢å¼å¼åå¨
温馨提示:答案为网友推荐,仅供参考