Re: RULES vs. COST
From: Jeff Perry <jp_at_vllyoak.resun.com>
Date: Sat, 18 Feb 95 09:27:26 PST
Message-ID: <FoBq1c3w165w_at_vllyoak.resun.com>
Date: Sat, 18 Feb 95 09:27:26 PST
Message-ID: <FoBq1c3w165w_at_vllyoak.resun.com>
Odischner_at_med.uni-muenchen.de (Anton Dischner) writes:
> In article <3havdo$91b_at_ams.amsinc.com>, Edward_Hillman_at_mail.amsinc.com (Ed
> Hillmann) wrote:
>
> > and there are rare instances where incorrect data
> > is
> > returned.
> I havn't heard that, --I HOPE THIS IS NOT TRUE--
> Please, if you have a demo if this bug post it!
YES, we had incorrect data (a year ago) using the cost based optimizer of 7.0.13.1. Given my workload at the time, I never followed up on this problem, so I don't have an example handy. We still run rule based optimization today.
-- Jeff Perry jp_at_vllyoak.resun.com or jp%vllyoak.resun.com%blkhole_at_sdd.hp.comReceived on Sat Feb 18 1995 - 18:27:26 CET