|
|
Archives of the TeradataForum
Message Posted: Thu, 26 Jun 2014 @ 16:11:09 GMT
Subj: | | Re: How to calculate the space consumed by Secondary index |
|
From: | | Newell, Ray |
You can use the Ferret showblocks/l command or the collect demographics command. The collect demographics will insert data into a QCD database
and then you can use the datademographicsview to select columns. Both the utility and command will display data by subtableids. With the ferret
utility look at the number of data blocks times the average block size.
With the collect demographics command, use the average row size times the number of rows.
| |