Archives of the TeradataForum
Message Posted: Mon, 15 Sep 2008 @ 16:02:54 GMT
| Subj: || || Re: Calculating total space for indexes |
| From: || || Rob Paller |
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.