Re: BITMAP index cost 10053 trace
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: Stephen.Barr@xxxxxxxxx
- Date: Tue, 24 May 2005 05:26:03 -0600
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
