NUSI subtable distribution

Database
Enthusiast

NUSI subtable distribution

Hi,

When i create NUSI,how the subtables are distributed among AMPS. Is there any rule as such?

Please explain.

Regards,
Mahesh.
4 REPLIES
Enthusiast

Re: NUSI subtable distribution

NUSI entries are located on the same AMP as the base row. For this reason, access via NUSI is always an all amps operation.
See Database Design, Secondary Indexes.
Enthusiast

Re: NUSI subtable distribution

Thanks jimm. do you mind sharing the link for that manual?
Senior Apprentice

Re: NUSI subtable distribution

You'll find all the manuals at www.info.teradata.com

Dieter
Enthusiast

Re: NUSI subtable distribution

thanks Dieter.