Archives of the TeradataForum
Message Posted: Mon, 01 Mar 2004 @ 10:16:37 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|