Re: Help: Strange sql behaviour

The thing is, index scan are faster, full table scan are slower, but oracle favor full table scan. If we use cost, I can understand, because Oracle can make mistakes in judging which is more expensive. What I can not understand is why in rule_based optimizer mode, Oracle still favor full table scan. I thought that rule based means that always use index if there is one.

Am I right?

Thanks
"Galen Boyer" <galenboyer_at_hotpop.com> wrote in message news:uwutyxg0e.fsf_at_rcn.com...
> On Mon, 20 May 2002, charlie.peltier(delete here-antispam)@verizon.net
> wrote:
>
> > But after we analyze table life,
>
> [...]
>
> > In the above three tables, we can only analyze two tables, life table
> > can not be analyzed
>
> Which is it?
>
> What is/are the plan/s?
>
> --
> Galen deForest Boyer
> Sweet dreams and flying machines in pieces on the ground.
Received on Tue May 21 2002 - 05:51:22 CDT