Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 09 May 2001 @ 11:10:11 GMT

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

Subj:   Re: Unique Row ID
From:   Claybourne Barrineau

Just out of curiousity, are you performing a csum(1,1) to get a unique row id. I tried this once, and I got the same results as you (hot amp.) However, if you perform a csum(1,('Primary Index Component #1' || 'Primary Index Component #2' || .....)) (assuming the PI is unique and you can maintain uniqueness somehow with a concatentation and all concatenated columns are not null), I think this will help. In theory, this approach should distribute your csum() across the amps based upon the distribution of your PI.

Good Luck,

Claybourne Barrineau

  <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