Re: Forcing index usage...

Volker Hetzer wrote:
> Hi!
> (9.2.0.6, linux)
> I'm in a situation where oracle spatial doesn't use a domain index even
> if I use the index hint.
> In fact, as long as the spatial operator (sdo_relate) is the only
> predicate in the where
> clause, the index gets used, so the index is okay.
> But as soon as I add more predicates or nest the query into another one,
> the index doesn't get used and the query takes forever.
>
> Is there anything I can do apart from the hint?

Impossible to tell without more info (Ora version, DDL, DQL...) but chances are that you can improve performance by adding indexes or changing existing indexes.

> I'm seriously considering splitting my query into two, the first one
> putting the spatial related results into a temporary table and the
> second one
> doing the rest with the intermediate result.

Don't do that.

Kind regards

        robert Received on Mon Apr 24 2006 - 11:32:12 CDT