Archives of the TeradataForum

Message Posted: Mon, 01 Mar 2004 @ 10:16:37 GMT

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

Rishi

Following on from Ulrich's comments, I would recommend that you use Multiload Delete.

You should consider the following:

Dropping the secondary indices. They are not used by mload and every block is affected. Also, SI's will cause a large work table to be created and the index application phase can be quite slow. So, it is better to drop the index and recreate after the rows have been deleted.

Also, remember, that the mload must complete. Therefore, you may need to consider archiving it before you commence the MLOAD.

Good luck

Frank

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