 |
 |
Archives of the TeradataForum
Message Posted: Fri, 26 Sep 2008 @ 21:14:12 GMT
| Subj: | | Re: Calculating total space for indexes |
| |
| From: | | Ramchandran, Janardhan |
| | Collect Demographics statement will populate the DataDemographics Table and you can use the DataDemographics view -->to pull the data
and easily calculate the index subtable sizes. Seems that many people are not aware of this statement, it is in the documentation. | |
Some time, row count for the indexes is wrong, so you can take the "average row size" from this QCD.Datademographics table, and put HELP
INDEXES for that column to get the approximate row count and calculate the size as (Avgrowsize*row count)/1024/1024/1024 to the index size.
Thanks & regards
Janardhan R
Teradata MS
| |
