re: speeding up SPATIAL QUERY ..

[hreddy007]

hi! ,

Heres my SPATIAL sql statement ..

Select ODPM2001_I From DFT.URBANAREAS U
Where SDO_RELATE(U.GEOLOC, obTempPt, 'mask=CONTAINS querytype=WINDOW') = 'TRUE'; -- querytype=WINDOW

I have put a spatial index on U.GEOLOC ....
The query takes too long.

I pose my challenge to you ..
How can I speed up this query ?
From the DBA side and/or the PL/SQL side ...

thanks,
Harish

[hrishy]

Hi

How does the expalin plan look like ?

regards
Hrishy