https:

## Message Posted: Thu, 10 Apr 2003 @ 14:52:12 GMT

 < Last>>

 Subj: NUSI calculation From: Rodrigo Cifuentes

I found a formula in Teradata Factory docs (PDBD student manual) to evaluate if a NUSI is appropriate in a column. The formula is

Typicall Rows per Value < (Typical Row Size / Typical Block size) (as a percentage of) Number of Rows in Table.

An example goes like this:

Typical Rows per Value = 2000
Typical Row Size = 480
Typical Block Size = 48000
Number of Rows = 100.000
480/48000 = 1/100 = 1%
1% of 100.000 = 1000

2000 < 1000 is false, so no NUSI should be built on the column.

Anybody knows the reasoning behind the formula? Why bigger rows 'allow' to have more repetitions on the NUSI/primary table? The only reason I can see is that the number of read on NUSI blocks is increasingly favorable when the number of records decreas in the data block. Is this the only reason?

 < Last>>

Attachments

Library

Quick Reference

Archives

Sample Index

 2016 2007 2015 2006 2014 2005 2013 2004 2012 2003 2011 2002 2010 2001 2009 2000 2008 1999

2003 Indexes

 Jan Jul Feb Aug Mar Sep Apr Oct May Nov Jun Dec

 Top Home Privacy Feedback