Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 30 Oct 2007 @ 12:00:01 GMT

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

Subj:   Re: Generate unique id
From:   Dieter Noeth

Barner Eric wrote:

  This is true, also I think it inherently has higher tendency to skew more so than the ROW_Number function.  

  Or the SUM(x) over(partition by ..... Order by ... Rows unbounded preceding) form.  

  Can anyone from Teradata confirm the tendency to skew with CSUM?  

I'm not from Teradata, but AFAIK CSUM is exactly the same as SUM OVER, it's skewing if there are not enough distinct PARTITION BY/ORDER BY values. Most stupid example would be CSUM(1,1).


  <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: 15 Jun 2023