[postgis-users] functions using index
ml at 3.141592654.de
Mon Jan 18 09:32:22 PST 2010
> On Fri, Jan 15, 2010 at 5:27 PM, Andreas Brandl <ml at 3.141592654.de>
> > Is it right to say that - from the set of OGC topology/measurement
> functions - the following are using the index?
> > Equals, Intersects, Touches, Crosses, Within, Contains, Overlaps
Thanks for your reply. Does this apply to both positive and negative cases, i.e. is the index used on both ST_Crosses(A, B) = 1 and ST_Crosses(A, B) = 0?
> And every query can use an index, by including an index operator (&&)
> in the query, so Relate() can take advantage of the index thusly
> select * from thetable where thegeom && theothergeom and
> ST_Relate(thegeom, theothergeom, '000000000');
Thanks for pointing this out.
More information about the postgis-users