We use H2 at my company, and I've been lurking on this list for a while. I can't give you a specific answer, and this suggestion may be off-target.
I have the notion that GROUP BY is fastest when there is also a HAVING clause. I would do an EXPLAIN PLAN for your query and especially for your subselect. Hope this helps. Bill Torcaso Operations Knome Inc. 25 First Street, Suite 107 Cambridge, MA 02141 USA [email protected] Phone: 617.715.1000 www.knome.com<http://www.knome.com/> The Human Genome Interpretation Company This e-mail is covered by the Electronic Communications Privacy Act, 18 U.S.C. ยงยง 2510-2521 and is legally privileged. This email contains confidential information intended only for the person(s) to whom this e-mail message is addressed. If you have received this e-mail message in error, please notify the sender immediately by telephone at (617) 715-1000 or by electronic mail ([email protected]) and destroy the original message without making a copy. Thank you. From: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Reply-To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Date: Sunday, September 8, 2013 12:12 AM To: Digest Recipients <[email protected]<mailto:[email protected]>> Subject: [h2] Digest for [email protected]<mailto:[email protected]> - 3 Messages in 2 Topics Views and H2<http://groups.google.com/group/h2-database/t/cbfe18166706a6e2> -- 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. For more options, visit https://groups.google.com/groups/opt_out.
