ä¸åæ°æ®åºä¸æä¾äºä¸åçç´¢å¼ç±»åï¼SQLServerä¸çç´¢å¼æ两ç§ï¼èéç´¢å¼(CLUSTEREDï¼åéèéç´¢å¼(NONCLUSTEREDï¼ã
ç´¢å¼åºå«ï¼
èéç´¢å¼ï¼
èéç´¢å¼åºäºæ°æ®è¡çé®å¼ï¼å¨è¡¨å
æåºååå¨è¿äºæ°æ®è¡ãæ¯ä¸ªè¡¨åªè½æä¸ä¸ªèéç´¢å¼ï¼åºä¸ºæ°æ®è¡æ¬ååªè½æä¸ä¸ªé¡ºåºåå¨ã
å¨èéç´¢å¼ä¸ï¼è¡¨ä¸åè¡çç©ç顺åºä¸ç´¢å¼é®å¼çé»è¾ï¼ç´¢å¼ï¼é¡ºåºç¸åãèéç´¢å¼é常å¯å å¿«UPDATEåDELETEæä½çé度ï¼å 为è¿ä¸¤ä¸ªæä½éè¦è¯»å大éçæ°æ®ãå建æä¿®æ¹èéç´¢å¼å¯è½è¦è±å¾é¿æ¶é´ï¼å 为æ§è¡è¿ä¸¤ä¸ªæä½æ¶è¦å¨ç£çä¸å¯¹è¡¨çè¡è¿è¡éç»ã
éèéç´¢å¼ï¼
å 为ä¸ä¸ªè¡¨ä¸åªè½æä¸ä¸ªèéç´¢å¼ï¼å¦æéè¦å¨è¡¨ä¸å»ºç«å¤ä¸ªç´¢å¼ï¼åå¯ä»¥å建为éèéç´¢å¼ã表ä¸çæ°æ®å¹¶ä¸æç
§éèéç´¢å¼åç顺åºåå¨ï¼ä½éèéç´¢å¼çç´¢å¼è¡ä¸ä¿åäºéèéé®å¼åè¡å®ä½å¨ï¼å¯ä»¥å¿«æ·å°æ ¹æ®éèéé®çå¼æ¥å®ä½è®°å½çåå¨ä½ç½®ã
延伸é
读ï¼
æ 论æ¯èéç´¢å¼ï¼è¿æ¯éèéç´¢å¼ï¼é½å¯ä»¥æ¯å¯ä¸ç´¢å¼(UNIQUE)
ãå¨SQL Serverä¸ï¼å½å¯ä¸æ§æ¯æ°æ®æ¬èº«çç¹ç¹æ¶ï¼å¯å建å¯ä¸ç´¢å¼ï¼ä½ç´¢å¼åçç»åä¸åäºè¡¨ç主é®ãä¾å¦ï¼å¦æè¦é¢ç¹æ¥è¯¢è¡¨aï¼è¯¥è¡¨ä¸»é®ä¸ºåa_idï¼çåa_nameï¼èä¸è¦ä¿è¯å§åæ¯å¯ä¸çï¼åå¨åa_nameä¸å建å¯ä¸ç´¢å¼ãå¦æç¨æ·ä¸ºå¤ä¸ªåå·¥è¾å
¥äºç¸åçå§åï¼åæ°æ®åºæ¾ç¤ºé误ï¼å¹¶ä¸ä¸è½ä¿å该表ã
追é®ä¸ç¥æ¯ä¸¤ç§è¿æ¯ä¸ç§äºããã