The well-known problems with using CBO to query the
statistics-less data dictionary had been resolved in Oracle9i, as discussed in
an earlier thread on this list. Not sure how they fixed it, but I suspect
that Oracle is not throwing away the RBO code-base, but rather absorbing the
more useful parts of it into the CBO for uses like querying the data
dictionary. Either that, or they have improved the constants applied in
the absence of statistics. Or both...?
|
Title: RE: But I *want* to use RBO!
- But I *want* to use RBO! Jesse, Rich
- RE: But I *want* to use RBO! Jamadagni, Rajendra
- RE: But I *want* to use RBO! Mercadante, Thomas F
- RE: But I *want* to use RBO! Jamadagni, Rajendra
- RE: But I *want* to use RBO! Jacques Kilchoer
- RE: But I *want* to use RBO! Cherie_Machler
- Re: But I *want* to use RBO! Tim Gorman
- Re: But I *want* to use RBO! Tim Gorman
- Re: But I *want* to use RBO! Scott Canaan
- Re: But I *want* to use RBO! Connor McDonald
- RE: But I *want* to use RBO! K Gopalakrishnan