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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: BITMAP index cost 10053 trace

Re: BITMAP index cost 10053 trace

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Tue, 24 May 2005 07:59:38 -0600
Message-ID: <4293334A.7000108@centrexcc.com>


I have high hopes that Jonathan Lewis' upcoming book will shed loght on this.

Barr, Stephen wrote:
> Is the formula available anywhere?
>

>>If the formula is blevel + FF*leaf_blocks + FF*clustering_factor then the
>>cost comes out as 11 - how does it then jump to 9131? I'm assuming the cost
>>calculationfor bitmap indexes is very different?

>
> I'm assuming you are right. :-)
>
-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 24 2005 - 10:04:27 CDT

Original text of this message

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