[postgis-users] functions using index

[Paul Ramsey]

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

Also DWithin()

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');

P

>
> And not: Distance, Disjoint, Relate? (This in fact is stated in the docs [1]).
>
> Thanks!
>
> Regards,
> Andreas
>
> [1] http://postgis.refractions.net/docs/ch04.html#id2717971
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>