 |
 |
Archives of the TeradataForum
Message Posted: Thu, 09 Mar 2006 @ 22:29:02 GMT
| Subj: | | Re: Mload performance issue due to Secondary indexes |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Thursday, March 09, 2006 17:29 -->
We use a similar kind of your second approach for loading huge tables. Secondary index creation shouldn't take that long. If the values of
the column on which the NUSI is created is highly skewed to a single AMP, then it would take more time and sometimes might run out of space under
that database/user. TPump is also another good option.
| |
