Archives of the TeradataForum

Message Posted: Fri, 07 Apr 2006 @ 21:33:40 GMT

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

It will not create always sequential integer numbers, but these numbers are unique. In most cases this option useful for audit table population by Triggers. You could consider this column as UPI for even distribution of data across AMPs. This is ok for inserts and deletions, but for access you need to create SI on most accessible column.

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