drop,truncateÓëdeleteµÄÇø±ð

ʱ¼ä£º2016.04.19 ·¢²¼ÈË£ºwmywxszc1000

drop,truncateÓëdeleteµÄÇø±ð

Òѽâ¾öÎÊÌâ

¹È¸èwmywxszc1000Óû§ÔÚ2016.04.19Ìá½»Á˹ØÓÚ¡°²ÌÐìÀ¤drop,truncateÓëdeleteµÄÇø±ð¡±µÄÌáÎÊ£¬»¶Ó­´ó¼ÒÓ¿Ô¾·¢±í×Ô¼ºµÄ¹Ûµã¡£Ä¿Ç°¹²ÓÐ1¸ö»Ø´ð£¬×îºó¸üÐÂÓÚ2025-03-01T03:18:27¡£Ï£Íû´ó¼ÒÄܹ»°ïÖúËý¡£

ÏêϸÎÊÌâÃèÊö¼°ÒÉÎÊ£ºÆÚ´ýÄúµÄ´ð°¸£¬¸ÐлÄã,ÎÒ»á¼ÇµÃÄã¶ÔÎÒµÄºÃµÄ £¡

Ï£ÍûÒÔϵĻشð£¬Äܹ»°ïÖúÄã¡£

µÚ1¸ö»Ø´ð

Óû§Ãû£ºhefeixu521  

×¢Òâ:ÕâÀï˵µÄdeleteÊÇÖ¸³§Ö°Ïú¾õƤ²»´øwhere×ÓÇï½ÚÔÓ묱øÉ̾äµÄdeleteÓïÃ˵÷ÉÕ»¤¾ä
Ïàͬµã
truncateºÍ²»´øwhere×Ó¾äµÄdelete,ÒÔ¼°drop¶¼»áɾ³ý±íÄÚµÄ**

²»Í¬µã:
1.truncateºÍdeleteֻɾ³ý**²»É¾³ý±íµÄ½á¹¹(¶¨Òå)
dropÓï¾ä½«É¾³ý±íµÄ½á¹¹±»ÒÀÀµµÄÔ¼Êø(constrain),´¥Ãûν·¢Æ÷(trigger),Ë÷ËɵÄÉÌÔðÒÑÒý(index);ÒÀÀµÓڸñíµÄ´æ´¢¹ý³Ì/º¯Êý½«±£Áô,µ«ÊDZäΪinvalid״̬.
2Äڵظĺþʯ²éÎö¼°ÀÍÁ¸ÏÔ.deleteÓï¾äÊÇdml,·áÕâ¸ö²Ù×÷»á·Åµ½rollbacksegementÖÐ,ÊÂÎñÌá½»Ö®ºó²ÅÉúЧ;Èç¹ûÓÐÏàÓ¦µÄtrigger,Ö´ÐеÄʱºò½«±»´¥·¢.
truncate,dropÊÇddl,²Ù×÷Á¢¼´½éɱÉÕÈ«µÛÆûÉúЧ,Ô­**²»·Åµ½rollbacksegmentÖÐ,²»Äܸᆴ¸±½**£´Ùɳ»Ø¹ö.²Ù×÷²»´¥·¢triµ×ǰÁ¼×Ô²¹ÒËgger.
3.deleteÓï¾ä²»Ó°Ïì±íËùÕ¼ÓõÄextent,¸ßË®Ïß(**watermark)±£¹Å³ÖԭλÖò»¶¯
ÏÔÈ»dropÓï¾ä½«±íËùÕ¼ÓõĿռäÈ«²¿ÊÍ·Å
truncateÓï¾ä¿ËΧË㹩ÑξöºôȱʡÇé¿öϽ«¿Õ¼äÊͷŵ½minextents¸öextent,³ý·ÇʹÓÃreusestÉÌÌá»ùÀàΣ°¡Ñ¹orage;truncate»á½«¸ßË®Ï߸´Î»(»Øµ½×ʼ).
4.ËÙ¶È,Ò»°ãÀ´Ëµ:droÈÔÖ´Ö¾Ñôp>;truncatÍÑѵ´ýÁòÕßÕûÖÂеƵe>;delete
5.°²È«ÐÔ:СÐÄʹÓÃdropºÍtruncate,ÓÈÆäûÓб¸·ÝµÄʱºò.·ñÔò¿Þ¶¼À´²»¼°
ʹÓÃÉÏ,Ïëɾ³ý²¿·Ö**ÐÐÓÃdelete,×¢Òâ´øÉÏwhere×Ó³ÂÄØÔØÂä»áºÎ³ʡ¼ÙסÍù¾ä.»Ø¹ö¶ÎÒª×ã¹»´ó.
Ïëɾ³ý±í,µ±È»ÓÃdrop
Ïë±£Áô±í¶ø½«ËùÓÐ**ɾ³ý.Èç¹ûºÍÊÂÎñÎÞ¹Ø,ÓÃtruncate¼´¿É.Èç¹ûºÍÊÂÎñÓйØ,»òÕßÏë´¥·¢trigger,»¹ÊÇÓÃdelete.
Èç¹ûÊÇÕûÀí±í**µÄË鯬,¿ÉÒÔÓÃtruncaÁùÂÔ¼þte¸úÉÏreusestroage,ÔÙÖØÐµ¼Èë/²å¹¤·¶°´ÍþÈë**

ͨË׵Ľ²£º

ÔÚʵ¼ÊÓ¦ÓÃÖУ¬ÈýÕßµÄÇø±ðÊÇÃ÷È·µÄ¡£
µ±Äã²»ÔÙÐèÒª¸Ã±íʱ£¬ÓÃdrop;
µ±ÄãÈÔÒª±£Áô¸Ã±í£¬µ«ÒªÉ¾³ýËùÓмǼʱ£¬ÓÃtruncate;
µ±ÄãҪɾ³ý²¿·Ö¼Ç¼ʱ£¨alwayswithaWh**EREclause),ÓÃdelete.