Archives of the TeradataForum

Message Posted: Mon, 13 Mar 2006 @ 17:28:01 GMT

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

Hi Everyone:

I have a question on PPI that I am hoping one of you has some insight. By default, Teradata builds the Master and Cylinder index entries sorted by RowHash value (highest) within TableID for each cylinder and block. This makes it easy and quick to find any row hash within the table.

When PPI is used and the data is sorted by the partition value, the Master and Cylinder index entries must be arranged differently (at least to a degree). Is there now some entry or combination of TableID or Row Hash to include the partition id to allow quick access to any particular Row Hash for a partition?

With that asked, I am mainly wondering for access using a USI without the partitioning value where it has traditionally stored only the RowID of the base data row. I appreciate any light that you might provide to help me better understand or direction for a particular Teradata document that contains this information.

Thanks in advance,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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