 |
 |
Archives of the TeradataForum
Message Posted: Thu, 09 Aug 2007 @ 09:11:24 GMT
| Subj: | | Re: Fastload + INS / SEL or MultiLoad |
| |
| From: | | David Clough |
I wonder whether Anomy Amos' concern over :-
| | For the 1st option the INS / SEL will, over a period of time, will become slower, as the Warehouse table increase in size.. Duplicate row
check etc. | |
is due to defining the NUPI table as SET. If so, define it as MULTISET and there will be no duplicate row check.
I know Multiset offends the sensibilities of some people - and we've had this discussion before - but we use it all the time without issue.
Regards,
Dave Clough
Database Designer
Express ICS
www.tnt.com
| |
