Archives of the TeradataForum

Message Posted: Wed, 29 Mar 2000 @ 17:47:16 GMT

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

Barbara,

The primary key only comes into play if you have referential integrity turned on. Beyond that, the primary index determines how evenly your data is distributed across the amps based on uniqueness. The best performance is from a unique primary index. All the data is distributed evenly acroos the amps, so all amps are working evenly to return rows selected using the primary index.

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