Forcing index usage...

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Mon, 24 Apr 2006 18:00:58 +0200
Message-ID: <e2isnq$so7$1@nntp.fujitsu-siemens.com>

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?

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.

Any thoughts on that?

Lots of Greetings!
Volker Received on Mon Apr 24 2006 - 11:00:58 CDT