Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 24 Jan 2012 @ 20:58:14 GMT

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

Subj:   Re: Unique index vs. primary index
From:   Poston, Donna

Hi Gabriel, you are getting more than one row that shares the same value for column prod_id. If you want to use the single column prod_id as a primary index, the PI should be a NUPI.

You should check the demographics of the prod_id and make sure there are not a lot of hash collisions for a give Primary index value. If the table is SET having a NUPI of prod_id, there can be a lot of duplicate row checks. A multiset table will not check for duplicate rows, but an exact duplicate can load to the table unless these are filtered out.

  <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