Archives of the TeradataForum

Message Posted: Tue, 16 Nov 2010 @ 07:52:58 GMT

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

<-- Anonymously Posted: Monday, November 15, 2010 15:52 -->

Hi Faible Mou,

You can find details on the three levels (master index, cylinder index, and data block) described earlier by Dieter on pages 371-374 in the 12.0 Teradata Database Database Design reference manual. You can also find more information in the 12.0 Teradata Database Database Design reference manual on the following:

- PI [pages 383-388]

- Differences between PI and PPI [pages 389 -404]

- Advantages and disadvantages of PPI [pages 404-405]

- PPI value retrieval access (the PPI and NPPI guidelines for selection) [pages 476-480]

Hope this information helps!

Thanks!

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