Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: estimate index size on 9i

Re: estimate index size on 9i

From: Steve Robin <ocmaman_at_gmail.com>
Date: 16 Jan 2007 21:45:25 -0800
Message-ID: <1169012725.255103.157530@m58g2000cwm.googlegroups.com>

Digeratus 2006 wrote:
> "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

If I have 4 columns than what Received on Tue Jan 16 2007 - 23:45:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US