Archives of the TeradataForum
Message Posted: Tue, 04 Jul 2006 @ 17:40:27 GMT
Subj: | | Re: Evaluation of the size of index in a system |
|
From: | | Victor Sokovin |
| I want to find a function/macro or a request wich give me easily the good information. | |
I don't have such a macro but I can provide the reference for the previous thread on the subject:
www.teradataforum.com/teradata/20060315_195124.htm
.
The general conclusion seems to be that it is difficult to calculate the exact index size using only SQL. However, it is not always hard
to make a reasonable estimate.
A better option than SQL is the utility called Ferret.
Regards,
Victor
|