Re: SW vendor insists on RBO

Niall Litchfield wrote:

> "Peter van Rijn" <pgm.van.rijnRM_at_THIShccnet.nl> wrote in message
> news:aoq2l7$a7l$1_at_news.hccnet.nl...
> > Now we're getiing to my point. I really intended to use the CBO, even when
> > our SW vendor advised against it, I'm pretty sure 8.1.7 CBO is usually
> > better than RBO. But now I have my doubts. What other surprises can I
> > expect? I never would have thought I'd encounter software problems because
> > of using another optimizer.
>
> In this case it seems to me that you are hitting software problems not
> because of the optimiser in use, but because of a bad design decision (to
> store inconsistent datatypes in the same column). In my book your app should
> either be treating the strings as strings OR storing numbers in a number
> field.
>
> Other things you should consider are the long list of new features that are
> not supported by the RBO and so either will not be used effectively (or will
> kick of the CBO), and wether the advice fronm the vendor is 'advice' or a
> support requirement.
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
> ******************************************

I agree with Niall. I'd be looking to see whether I could dump the vendor. Obviously their knowledge of Oracle leaves much to be desired.

Could you possibly do others a favour and name names?

Thanks.

Daniel Morgan Received on Mon Oct 21 2002 - 12:08:53 CDT