Re: Big table data truncate or delete
Again, truncate drops the table then recreates it as an empty table. That's pretty quick. I cannot imagine it taking longer than a sequence of chunk deletions.
No need to take my word for it. You have a MySQL server right in front of you. Benchmark it for yourself.
Subject
Written By
Posted
February 23, 2022 07:57AM
February 23, 2022 11:34AM
February 23, 2022 12:40PM
Re: Big table data truncate or delete
February 23, 2022 02:37PM
February 27, 2022 07:55PM
Sorry, only registered users may post in this forum.
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.