Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 11 Feb 2002 @ 22:32:59 GMT

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

Subj:   Re: Insert data into table
From:   Buckland

The big reason that some people choose Multiset over Set tables is for load time, especially with MultiLoad. If the table being loaded has a lot of duplicates on the Non Unique Primary Index then the duplicate row checking can take a long time, even if there are no duplicates in the full row. Redefining the table to Multiset does away with the duplicate checking. I once saw the monthly load time on a table with lots of NUPI dups go from 18 hours to 40 minutes once this change was made.

So it can be of use even if Mr Codd is still honored.

Mike Buckland

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020