Archives of the TeradataForum

Message Posted: Mon, 16 Sep 2002 @ 17:09:37 GMT

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

Hi:

If you are dropping a table and then creating it, is it safe to say you simply want an empty table?

If so, do not drop the table. Simply do the following:

DELETE ;

It gives you an empty table and it is the fastest thing that Teradata does!

I have seen many people who are use to another database, where dropping and creating is faster. This is not your father's database that actually writes over deleted data. In Teradata, it is much slower to drop and create than to delete. Plus, you are locking the data dictionary (DD) two different times to do this. Deleting does not lock the DD.

Hope this helps.

Mike

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