MySQL Forums
Forum List  »  Database Administration & Monitoring

Advanced Search
New Topic

Re: Big table data truncate or delete
Posted by: Peter Brawley
Date: February 23, 2022 11:34AM

Truncate works by dropping the table then recreating it, much faster than chunk deletion.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Big table data truncate or delete
Peng Wang
February 23, 2022 07:57AM
Re: Big table data truncate or delete
Peter Brawley
February 23, 2022 11:34AM
Re: Big table data truncate or delete
Peng Wang
February 23, 2022 12:40PM
Re: Big table data truncate or delete
Peter Brawley
February 23, 2022 02:37PM
Re: Big table data truncate or delete
Peng Wang
February 27, 2022 07:55PM
Re: Big table data truncate or delete
Pawel Wtorek
August 18, 2022 08:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.