Re: estimate index size on 9i

"oracle dba" <aoracledba_at_gmail.com> wrote in news:1168929159.960451.140580 @q2g2000cwa.googlegroups.com:

> hi all,
>
> in oracle 10g we can use dbms_space package to find estimate index size
> before create that one. How it is possible in oracle 9i.
>

You can RTFM, but a simple rule of thumb is (length of all of the columns in the index) * (number of rows) *

         (the size of your thumb)
My thumb is 1.5

• digeratus