Archives of the TeradataForum
Message Posted: Thu, 24 Oct 2002 @ 15:44:33 GMT
| Subj: | | Re: Table Space |
| |
| From: | | Raghav Vaidya |
The way you determine that depends upon whether the SI is unique or not. In case of a USI, you can multiply the number of rows by the
length of the index + 25 overhead. The SI subtable, in this case, is going to have 1 row for each row of the base table.
In case of a NUSI, the equation gets a little complicated. The way I do it is (if possible becasue of different restrictions such as
space) note how much space the table occupies, add the NUSI and then check again. That will give the space that the index is occupying.
There is a formula that is used to calculate the spaces. You should be able to find it in the Teradata DBA manual.
Raghav Vaidya....
| 
