Re: SW vendor insists on RBO

In message <aoq2l7$a7l$1_at_news.hccnet.nl> , Peter van Rijn <pgm.van.rijnRM_at_THIShccnet.nl> writes

>We ran across a problem I never would have imagined: CBO provoked an
>ORA-1722 (invalid number) error. I'll explain.
>
>We have this rather small table (the smallness is crucial) which is used to
>store (and query of course) domains. There is a column for low values, one
>for high values. The table is queried by supplying the domain name (which is
>part of an index) and supplying the low value field. Since the numeric low
>and high values are stored in a VARCHAR2 the to_number function is being
>used to do the conversion. Now were getting close.

Coo... this sounds like the cg_ref_codes table used by applications generated with Oracle Designer... ugly... spent a few hours wondering what had happened, but easy to fix by just dropping the statistics on that table.

Andy

-- 
Andy Hardy. PGP ID: 0xA62A4849