Re: How to calculate the size of an index?

From: Steve Howard <stephen.howard_at_us.pwcglobal.com>
Date: 12 Jan 2004 12:54:38 -0800
Message-ID: <6d8b7216.0401121254.7f99fd2@posting.google.com>

jeffyee_at_hotmail.com (Jeffrey Yee) wrote in message news:<ec4cec95.0401120502.6f4b273_at_posting.google.com>...
> Dear all,
>
> To calculate the size of a table, I usually use num_rows *
> avg_row_len. But how to I calculate the size of an index? Do I use
> avg_data_blocks_per_key * distinct_key * db_block_size of the
> database?
>
> Please advice. Thank you.
>
> Best Regards,
> Jeffrey Yee

Look up "ANALYZE INDEX...VALIDATE STRUTCURE" in the docs.

HTH, Steve Received on Mon Jan 12 2004 - 14:54:38 CST