Your life table has a column of type MDSYS.SDO_GEOMETRY and you are
selecting out l.GEOLOC.SDO_ORDINATES geom. The RBO doesn't get updated for
new features (like Oracle Spatial). Can you try as an experiment creating a
table as select * from life but without the GEOLOC column and then seeing if
you get the same behaviour.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"charlie.peltier" <charlie.peltier(delete here-antispam)@verizon.net> wrote
in message news:KEpG8.10333$Ou5.8696_at_nwrddc03.gnilink.net...
> 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 - 08:06:06 CDT
