There is a num_rows in user_indexes, and
a leaf_blk total space usage in index_stats.
Dividing one into the other should give you a
good idea.
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )
____UK_______March 19th
____USA_(FL)_May 2nd
Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )
____USA_(CA, TX)_August
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Bass Chorng wrote in message ...
>Is there a way to figure out the average row length of an index ?
>
>I looked dba_indexes and index_stats, there is no such
>information.
>
>I could use avg_col_len in dba_tab_columns plus whatever
>is needed for rowid to guess it out. But is there a more
>reliable and more direct way to get this information ?
>
>Thanks.
Received on Fri Feb 07 2003 - 02:25:10 CST
