Re: estimate index size on 9i

On Jan 17, 6:45 am, "Steve Robin" <ocma..._at_gmail.com> wrote:
> Digeratus 2006 wrote:
> > "oracle dba" <aoracle..._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
>
> > - digeratusIf I have 4 columns than what- Hide quoted text -- Show quoted text -

Read the formula posted by Digeratus *carefully*. Doesn't (length of all of the columns in the index) already provide the answer?

-- 
Sybrand Bakker
Senior Oracle DBA