Re: OPTIMIZER_MODE ???

From: Ronny <ivarsen_at_online.no>
Date: 1998/02/02
Message-ID: <34D64CAA.7CE9@online.no>#1/1

Nabil Courdy wrote:
>
> I am unable to set OPTIMIZER_MODE = COST under
> 7.3 on NT 4.0. It only accepts RULE or CHOOSE.
> I read somewhere in the Advanced Tuning book that is
> is best to set it at either COST or RULE. Any idea?
>
> Nabil Courdy
> moab_at_emirates.net.ae
> ==================
> --
>

In my experience, RULE will give the best overall result, but you want to override with hints whenever possible.

Ronny Ivarsen
ivarsen_at_online.no Received on Mon Feb 02 1998 - 00:00:00 CST