[postgis-users] functions using index
pramsey at cleverelephant.ca
Fri Jan 15 18:29:40 PST 2010
On Fri, Jan 15, 2010 at 5:27 PM, Andreas Brandl <ml at 3.141592654.de> wrote:
> 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
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');
> And not: Distance, Disjoint, Relate? (This in fact is stated in the docs ).
>  http://postgis.refractions.net/docs/ch04.html#id2717971
> postgis-users mailing list
> postgis-users at postgis.refractions.net
More information about the postgis-users