Archives of the TeradataForum

Message Posted: Sun, 20 Aug 2006 @ 14:48:51 GMT

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

Chandana,

On a table with PPI you are not allowed to create a UPI unless the entire set of partitioning data is included in the Primary Index , thus you may only have (normally) a NUPI on the PPI table. And because of this the rows are sorted primarily on the PPI then on the row-hash.

John

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