Table mapfriends."user" has a geometry field,and i create spatial index on it ,<br>and do <span><strong class="command">VACUUM ANALYZE,but when i use explain like that:</strong></span><br>explain SELECT * FROM mapfriends."user" where geometry @ mapfriends.ST_BUFFER(mapfriends.geometryfromtext('POINT(119.58 31.99175)'),0.1);<br>
<br> <br>It shows:<br><br><b>Seq Scan on "user" (cost=0.00..41682.57 rows=1053 width=244)</b><br><br>The spatial index seems not be used.<br><br>How should i do?<br><br>