Archives of the TeradataForum

Message Posted: Thu, 16 Mar 2006 @ 18:31:46 GMT

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

"Database Design V2R6" suggests the following formula:

     NUSI subtable size = 8 * Cardinality
                                + NumDistinct * (IndexValueSize + 21) * MIN (NumAMPs | Rows per value ) .

It is not exactly an easy formula to calculate the size correctly but I hope it will help you identify your "leaders". Look at the largest tables (because of the Cardinality) and NUSI defined on multiple columns (IndexValueSize). They can be promising candidates.

While looking at the formula I started doubting about this factor of 8. Shouldn't it now be 10?

Regards,

Victor

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