[postgis-users] Using both && and ST_Intersects in a query
Andrea Peri 2007
aperi2007 at gmail.com
Thu Sep 23 09:24:48 PDT 2010
Hi,
reading the thread "Difference between ST_Intersects and && operator "
If I understand exactly
this mean that a query filter like this:
select ...
from
table1 as a,
table2 as b
where
( (a.geom && b.geom) && (ST_Intersects(a.geom,b.geom)=true ) )
if faster than a query without the &&
like this:
select ...
from
table1 as a,
table2 as b
where
( ST_Intersects(a.geom,b.geom)=true )
I understand correctly ?
Thx,
Andrea Peri.
More information about the postgis-users
mailing list