[postgis-users] PERFORMANCE PROBLEMS

[Alvaro Zabala]

Hi! Im developing an app which acceses PostGIS with JDBC. I have a table 
with a geometry column, and Ive created an spatial index on this geometry 
column. The main query is like this:
<query>
SELECT  asText(GEOMETRY) AS GEOMETRY,C_PV,C_OCA,D_OCA,GID FROM ocas WHERE 
GEOMETRY && 'BOX3D(88034.16 3926963.056375266, 634143.4400000001 
4339164.943624733'::box3d
</query>

I've noticed that this is a very slow query.
May I force the use of the spatial index? How can I do that?
May I use instead of this query a PostgreSQL cursor?
What are advantages of cursor?
Thanks in advance!!

_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
http://join.msn.com/?page=features/junkmail