Archives of the TeradataForum
Message Posted: Fri, 12 Nov 2010 @ 19:37:05 GMT
| Subj: | | Re: SI and load utilities |
| |
| From: | | Fred W Pluebell |
FastLoad does not support any secondary index maintenance; that's one of the tradeoffs for being "Fast". But it doesn't compare rows one at a
time against previously inserted data either - it sorts and removes duplicates in Phase 2 after all the data has been loaded.
MultiLoad Apply phase is by design "AMP local". NUSI entries are located on the same AMP as the table row, so NUSIs are supported. But USI
entries are hashed to different AMPs based on the SI values, so those are not supported.
| 
