Re: Forcing index usage...

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Tue, 25 Apr 2006 12:55:59 +0200
Message-ID: <e2kv7v$7kk$1@nntp.fujitsu-siemens.com>

HansF schrieb:
> On Mon, 24 Apr 2006 18:00:58 +0200, Volker Hetzer wrote:
>
> You probably want to use the *Ordered* hint.
>
> Spatial is a wierd beast when it comes to using indexes. I strongly
> encourage you purchase Apress' 'Pro Oracle Spatial' book to get a good set
> of examples. And yes, the ordered hint is used a lot to ensure the system
> drives through the right tables and predicates.
>
> http://apress.com/book/bookDisplay.html?bID=315
Got that book on my desk.
The examples are rather simple, but from what I gleam there's another avenue in disabling all other indexes. Can't say I like it though.

Also, the book I got is mostly 10g. Seems oracle has thrown in the towel too and provided sdo_join instead. I think I'll do that and reimplement it for 9i. A pipelined pl/sql function that returns pairs of rowid's looks doable.

Lots of Greetings and thanks!
Volker Received on Tue Apr 25 2006 - 05:55:59 CDT