Re: BITMAP index cost 10053 trace

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Tue, 24 May 2005 05:26:03 -0600
Message-Id: <6.2.0.14.2.20050524052506.042e2428@pop.centrexcc.com>

At 02:33 AM 5/24/2005, Barr, Stephen wrote:
>I'm trying to resolve how the CBO has come up with the cost of 9131 in the
>10053 extract below.
>
>
>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 - 07:30:58 CDT