 |
 |
Archives of the TeradataForum
Message Posted: Fri, 27 Jun 2014 @ 10:13:29 GMT
| Subj: | | Re: How to calculate the space consumed by Secondary index |
| |
| From: | | Asifuddin MD |
Ray Newell wrote:
| | 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. | |
Dont we dump explain into qcd which inserts data there. To my knowledge Collect stats never inserts anything in qcd. Need to check.
Thanks
| |
