Archives of the TeradataForum

Message Posted: Wed, 12 Apr 2006 @ 11:46:42 GMT


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

Subj:		Re: Building row numbers

From:		David Wellman

Hi Chaim,

Summing that you want unique values for "rownumber" then CSUM is probably good enough. One thing to change though is the second '1' in your syntax. Any constant in this position will cause the query to skew horribly. I'd change it to one or more columns that are reasonably unique - such as CSUM(1,col1,col2,col3...). That should reduce the skewing.

Cheers,

Dave

Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )