[postgis-users] seq scan for spatial operator

[Xavier Vanderstukken]

The following query performs seq scan on all the table (600.000row for 
1matched result).

select * from foo where equals (asText(foo.geom),'POLYGON ((4.3596 
50.51121,4.3597584 50.51127,4.35994 50.511333,4.3601313 50.511406,4.360355 
50.511482,4.35968 50.511448,4.3596 50.51121))')

-->30sec response time

but if I add and intersect request :
foo.geom&& GeometryFromText('.............',-1)

-->response time 50ms no seq scan

_________________________________________________________________
Protégez votre boîte de réception: Phishing : comment l'identifier, le 
signaler et l'empêcher   http://www.fr.msn.be/security/phishing/