[postgis-users] Using both && and ST_Intersects in a query

[Andrea Peri 2007]

 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.

_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users