Archives of the TeradataForum

Message Posted: Tue, 02 May 2006 @ 09:49:15 GMT

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

You need to read the documentation. The idenity column provides a unique number, not a sequential number. Although it is basically sequential on an AMP, you probably have more than one AMP on your system. Hence the disparity.

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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