ããDelete ï¼å é¤æ°æ®è¡¨ä¸çè¡ï¼å¯ä»¥å é¤æä¸è¡ï¼ä¹å¯ä»¥å¨ä¸å é¤æ°æ®è¡¨çæ åµä¸å é¤ææè¡ï¼ã
å é¤æä¸è¡ï¼ããTruncateï¼å é¤æ°æ®è¡¨ä¸çæ°æ®ï¼ä» æ°æ®è¡¨ä¸çæ°æ®ï¼ä¸å é¤è¡¨ï¼ã
truncate table æ°æ®è¡¨å称ããTRUNCATE TABLEè¯å¥æ¯ä¸ç§å¿«éãæ æ¥å¿è®°å½çæ¹æ³ãTRUNCATE TABLEè¯å¥ä¸ä¸å«æ WHERE åå¥ç DELETE è¯å¥å¨åè½ä¸ç¸åãä½æ¯ï¼TRUNCATE TABLEè¯å¥é度æ´å¿«ï¼å¹¶ä¸ä½¿ç¨æ´å°çç³»ç»èµæºåäºå¡æ¥å¿èµæºã
ããå é¤æ°æ®çé度ï¼ä¸è¬æ¥è¯´: drop> truncate > delete
ããä¸ DELETE è¯å¥ç¸æ¯ï¼TRUNCATE TABLEè¯å¥å ·æ以ä¸ä¼ç¹ï¼
ããæç¨çäºå¡æ¥å¿ç©ºé´è¾å°ã
ããDELETE è¯å¥æ¯æ¬¡å é¤ä¸è¡ï¼å¹¶å¨äºå¡æ¥å¿ä¸ä¸ºæå é¤çæ¯è¡è®°å½ä¸é¡¹ãTRUNCATE TABLE éè¿éæ¾ç¨äºåå¨è¡¨æ°æ®çæ°æ®é¡µæ¥å é¤æ°æ®ï¼å¹¶ä¸å¨äºå¡æ¥å¿ä¸åªè®°å½é¡µéæ¾ã
ãã使ç¨çéé常è¾å°ã
ããå½ä½¿ç¨è¡éæ§è¡ DELETE è¯å¥æ¶ï¼å°éå®è¡¨ä¸åè¡ä»¥ä¾¿å é¤ãTRUNCATE TABLE å§ç»éå®è¡¨å页ï¼èä¸æ¯éå®åè¡ã
ããå¦æ ä¾å¤ï¼å¨è¡¨ä¸ä¸ä¼çæä»»ä½é¡µã
ããæ§è¡ DELETE è¯å¥åï¼è¡¨ä»ä¼å å«ç©ºé¡µãä¾å¦ï¼å¿ é¡»è³å°ä½¿ç¨ä¸ä¸ªæä» (LCK_M_X) 表éï¼æè½éæ¾å ä¸ç空表ãå¦ææ§è¡å é¤æä½æ¶æ²¡æ使ç¨è¡¨éï¼è¡¨ï¼å ï¼ä¸å°å å«è®¸å¤ç©ºé¡µã对äºç´¢å¼ï¼å é¤æä½ä¼çä¸ä¸äºç©ºé¡µï¼å°½ç®¡è¿äºé¡µä¼éè¿åå°æ¸ é¤è¿ç¨è¿ ééæ¾ã
ããä¸ DELETE è¯å¥ç¸åï¼ä½¿ç¨ TRUNCATE TABLEè¯å¥æ¸ 空ç表çå®ä¹ä¸å ¶ç´¢å¼åå ¶ä»å ³è对象ä¸èµ·ä¿çå¨æ°æ®åºä¸ã
ãã