Archives of the TeradataForum

Message Posted: Wed, 05 Jul 2006 @ 17:32:13 GMT

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

Hi Manoj

As of i know

When Secondary index is created subtable is created for each table and subtable records( SI index value, Base RowID , Subtable Row id ) are stored on the same amp or in different amps based on USI or NUSI values.

Thanks

Ganesh

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