Hi, > 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 )
This would be true if ST_Intersects would'nt already include a bounding box intersection step before trying the real intersection algorithm. The magic is already in PostGIS :) But you can try the difference with _st_intersects, which only does the geometric intersection without the bbox comparison first. Vincent -- Vincent Picavet - [email protected] www.oslandia.com - Engineering your GIS _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
