Archives of the TeradataForum

Message Posted: Mon, 15 Sep 2008 @ 16:02:54 GMT

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

I am pretty sure you can use the ferret utility to accomplish this. (It has been discussed in past threads available on the TeradataForum's website) The manuals also refer to a formula that can be used to calculate this by hand (or with the help of a spreadsheet).

I have not yet found or perfected a method using SQL to accurately determine a NUSI index size. I imagine it can be done based on the information in the data dictionary and profiling the data to obtain both cardinality and the average length of variable width data. USIs should be pretty straight forward in SQL using the formula's in the manuals.

HTH

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