hi! ,

Heres my 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 ....It 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