[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