Discussion about user defined index on OTHER type.
In spatial SQL the following request on an indexed geometry column would
use spatial index:
select * from spatialTable where ST_Intersects(the_geom,
> ST_PolyFromText('POLYGON ((67 13, 67 18, 59 18, 59 13, 67 13))',1));
>
Usage of ST_Intersects filter the_geom field by using BoundingBox stored
index of the spatialTable, then the method is applied on filtered rows.
Can I do this by creating my own TableEngine ? There is an easier way
without modifying the sql request ? Maybe a way to let special kind of
function to alter the execution plan ?
Thanks for your support.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
