|
|
Archives of the TeradataForum
Message Posted: Fri, 27 Jun 2014 @ 15:29:50 GMT
Subj: | | Re: How to calculate the space consumed by Secondary index |
|
From: | | Newell, Ray |
Again, what you need is to be able to space consumed by subtableid. It is easy to see using either the showblocks /l command in Ferret or use
the collect demographics statement. Much easier than stepping through adding SIs and comparing size, especially if tables are large. Using
showblocks or collect demographics only takes a few minutes.
| |