H2 isn't smart enough to do index-only scans, particular for aggregate
queries.
Patches are welcome :-)
On 2012-12-05 17:13, martin wrote:
I'm seeing the following result from explain analyze. Why doesn't the
composite index get used for this query? Is there anyway I can get it
to? I have run ANALYZE on the db. There are millions of rows in the
table.
--
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.
