Re: Big table data truncate or delete
Posted by: Peng Wang
Date: February 23, 2022 12:40PM

My concern is the performance impact during the truncate. If I truncate a 1TB size table has a lot of performance impact, should I do it with delete?

I know in Oracle, truncate would be better but I saw some discussion that the truncate could impact the performance?

Thanks Brian

Options: ReplyQuote

Written By
February 23, 2022 07:57AM
Re: Big table data truncate or delete
February 23, 2022 12:40PM

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.