Re: How do I calculate the size of indexes

In article
<1c7cc2f2.874137a2_at_usw-ex0101-005.remarq.com>, anurag <aminochaNOamSPAM_at_unibiz.com.invalid> wrote:
>Hi,
>I want to calculate the size of my indexes. Please help me out.
This level of detail isn't worth the trouble. If you have time for it, or your DASD is so small that you really need to do it, then something is wrong.

Summarization may be of some use. Compare the sum of the bytes of all of the table segments to the sum of the bytes of all of the index segments. I was surprised to discover that my indexes occupied 140% of the space of my tables. When you're estimating space for a new database, knowing this ratio from a few other databases can be helpful.

Paul de Anguera | "You can't write a chord ugly enough to say
Reply to:       | what you want to say sometimes, so you have to
deanguer@       | rely on a giraffe filled with whipped cream."
quidnunc.net    | - Frank Zappa