Archives of the TeradataForum

Message Posted: Fri, 23 Jul 2004 @ 14:12:01 GMT

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

I think there is nothing like TRUNCATE in Teradata as data records are distributed randomly across all the processing units. To delete a large percentage of records from your table you can use Multiload Delete Task. It is quite fast.

Sandipan

Teradata Certified Master
Wipro Technologies

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