Hi Emily,
Could you post the explain plan of that query? I ran a similar query
and it did use the index.
Regards,
Peter
> SELECT "ID","geom" as "geom" FROM "TESTDATA"
> WHERE "ID" IN (
> SELECT CAST (HATBOX_JOIN_ID AS INT)
> FROM
> HATBOX_MBR_INTERSECTS_ENV('PUBLIC', 'TESTDATA', -139.17094658129298,
> -113.94051433313055, 44.17730198523503, 64.12298153276885)
> )
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
