[postgis-users] spatial query don't use index!

[lee yishh]

 Table mapfriends."user" has a geometry  field,and i create spatial index on
it ,
and do *VACUUM ANALYZE,but when i use explain like that:*
explain SELECT * FROM mapfriends."user" where    geometry @
mapfriends.ST_BUFFER(mapfriends.geometryfromtext('POINT(119.58
31.99175)'),0.1);


It shows:

*Seq Scan on "user"  (cost=0.00..41682.57 rows=1053 width=244)*

The spatial index seems not be used.

How should i do?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090618/ed0bddf1/attachment.html>