Archives of the TeradataForum

Message Posted: Tue, 19 Oct 2010 @ 11:38:29 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Delete all is much faster as it deletes all rows from your table. There is no possibility to delete only some records using delete all. If you use delete all - you should delete all the rows. Why should you use delete all? Because it gives you gain in performance, i.e. big tables will be deleted faster using the statement.

Best regards,

Dmitriy Boyko

	<Prev	Next>		<<First	<Prev	Next>	Last>>