Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 22 Feb 2002 @ 21:26:26 GMT

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

Subj:   Re: NUPI considerations
From:   Ruth Fenwick


My row size is fairly small ~50 bytes. I'll have to check with the application team doing the MLOADs, but they should be able to ensure uniqueness via the load (one of the PK columns is date).

Is your experience that using Multiset without adding a USI will still achieve good performance? It's a weekly MLOAD that adds 15 million rows at a time. I had some concerns with the NUPI Duplicate row check that would take place.

And you're right, I'm seeing some wicked spool and redistribution happening. We're paying a high price for a poor PI choice.

Ruth Fenwick
IA&DSS Team Leader, IRM
Hudson's Bay Company

  <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