Re: Cost based Optimizer
From: Bruce W. Robinson <BRUCE_W_ROBINSON_at_CCM.JF.INTEL.COM>
Date: 1996/11/08
Message-ID: <3283CB76.9EC_at_CCM.JF.INTEL.COM>#1/1
Date: 1996/11/08
Message-ID: <3283CB76.9EC_at_CCM.JF.INTEL.COM>#1/1
Murali Kazhipurath wrote:
>
> .... The execution plan clearly shows that the RULE based
> optimizer is using indexes and the COST based optimizer is doing a full
> table scan. Any ideas???
>
> Murali
One tip: look for low cardinality in the selection columns. Cost/Choose optimizer won't use an index on a column with sparse values, like 'Y' or 'N'.
66
>
^ ....................... brucerReceived on Fri Nov 08 1996 - 00:00:00 CET