Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: estimate index size on 9i
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
![]() |
![]() |