Your cost begin at value 0.00. The index is in use.
-----Ursprüngliche Nachricht-----
Von: [email protected]
[mailto:[email protected]] Im Auftrag von lee yishh
Gesendet: Donnerstag, 18. Juni 2009 08:34
An: [email protected]
Betreff: [postgis-users] spatial query don't use index!
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?
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
