I have been using "delete from table_xyz" to delete everything in the table. Would it be better to instead use truncate? What difference does it make?
closed as unclear what you're asking by Colin 't Hart, Mr.Brownstone, Md Haidar Ali Khan, Vérace, Kin Shah Oct 29 '18 at 1:09
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
My short answer is:
truncate if you do not see any errors (because
truncate cannot be used in many scenarios, such as the table is referenced or the table is in replication, but you will get error in such cases)
The advantages of
delete esp. in your repeated deletion case) are:
- fast as it does not involve big overhead of transaction logging.
- much smaller footprint on database log.
Hope this helps !