Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Forcing index usage...

Re: Forcing index usage...

From: HansF <News.Hans_at_telus.net>
Date: Mon, 24 Apr 2006 16:58:36 GMT
Message-Id: <pan.2006.04.24.16.02.05.86885@telus.net>


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

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***
Received on Mon Apr 24 2006 - 11:58:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US