Re: Rule-based vs Cost-based Optimizer?
From: Rashpal Singh <rsingh_at_ix.netcom.com>
Date: 19 Mar 1995 21:07:34 GMT
Message-ID: <3ki6em$hib_at_ixnews4.ix.netcom.com>
Date: 19 Mar 1995 21:07:34 GMT
Message-ID: <3ki6em$hib_at_ixnews4.ix.netcom.com>
In <acc-1903951037230001_at_pfox.magna.com.au> acc_at_pfox.dialix.oz.au (Andrew Calvin) writes:
>
>In article <3k73qj$34b_at_potogold.rmii.com>, bromberg@hobbes (Rich
Bromberg)
>wrote:
>> the cost-based optimizer in a 7.0.16 and 7.1.3 ... have observed a
>number of extremely poor 'decisions' by the optimizer.
>
>I have experienced the same problem, so we have returned to rule-based
>optimisation at all times.
>
>-- Andrew Calvin -- acc_at_pfox.dialix.oz.au --
>
Don't forget to populate your system dictionary with statistics used by the cost-based optimizer. Look at the "analyze table ... estimate statistics". Received on Sun Mar 19 1995 - 22:07:34 CET