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
Good thing your thumb isn't a bitmap, or a bitmap join, or compressed,
or worse. ;-)
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Jan 16 2007 - 16:59:58 CST
