Archives of the TeradataForum

Message Posted: Mon, 17 May 1999 @ 18:45:54 GMT

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

The reason for this approach was due to the way Teradata used to execute drop table.

This function used to be very expensive. A delete was much faster. This is why the MSI tool used this approach. It would delete all from the table but leave the table definition to speed up the queries(without the drop on 5-100 tables / Report at 2-25 seconds / drop on a busy system.)

Now that we have Volitile temp tables we should look into using these as an approach to this problem.

Thanks,

Eric

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