Re: Rule-based vs Cost-based Optimizer?

From: Barry Roomberg <barry_roomberg_at_iacnet.com>
Date: Thu, 16 Mar 1995 13:52:22 GMT
Message-ID: <D5JD7D.AI6_at_zcias2.ziff.com>


In article <3k73qj$34b_at_potogold.rmii.com>, bromberg_at_hobbes (Rich Bromberg) says:
>

 .>
>We plan to run a formal test when we upgrade to 7.1.4. If the results are
>still mixed, we will probably switch back to rule-based. I have heard from
>a number of other installations which have already yanked the cost-based
>optimizer. It really is too bad that the CBO is still bug-ridden, since
>many installations run ad-hoc clients which do not allow for query tuning.
>
>--
>
>-------------------------------------------------------------------
>Rich Bromberg | dbINTELLECT Technologies, Inc.
>Database Consultant | Lakewood, Colo.
> | (303) 763-3822
> | email: bromberg_at_dbintellect.com
> | fax: (303) 763-4262
>-------------------------------------------------------------------

I just went to 7.1.4 for 7.0.16, and my initial testing of the CBO is that they might have finally fixed it. I'll post a followup after more exhaustive tests. Received on Thu Mar 16 1995 - 14:52:22 CET

Original text of this message