Archives of the TeradataForum

Message Posted: Sun, 20 Aug 2006 @ 10:05:28 GMT

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

Hi,

In a partitioned primary index, the rows are stored first by partition and then by row hash.

Within the partitions, the rows are sorted by row hash.

If I create a non-partitioned UPI on a table, are the rows sorted according to row hash?

Regards,

Chandana

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