Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to calculate the size of an index?
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
Received on Mon Jan 12 2004 - 07:02:42 CST