Sizing a Non‑Unique Secondary Index Subtable
Estimate the size of your non-unique secondary indexes using the equation provided in “NUSI Sizing Equation” on page 864.
For details on NUSI subtable row layouts, see “NUSI Row Structure” on page 468.
The number of base tables that can be referenced is limited by the maximum row size for the system and the length of the secondary index value. See “NUSI Sizing Equation” on page 864 for more information about sizing NUSI subtables.