<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Nachricht</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.3562" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=594102407-18062009><FONT face=Arial color=#0000ff size=2>Your
cost begin at value 0.00. The index is in use.</FONT></SPAN></DIV>
<DIV><SPAN class=594102407-18062009></SPAN> </DIV>
<DIV></DIV>
<DIV><FONT face=Tahoma size=2>-----Ursprüngliche Nachricht-----<BR><B>Von:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>Im Auftrag von </B>lee
yishh<BR><B>Gesendet:</B> Donnerstag, 18. Juni 2009 08:34<BR><B>An:</B>
postgis-users@postgis.refractions.net<BR><B>Betreff:</B> [postgis-users] spatial
query don't use index!<BR><BR></DIV></FONT>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">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></BLOCKQUOTE></BODY></HTML>