Otherwise another trick you can try is manually sharding your query, something like
SELECT ... WHERE docid % 10 == 0 SELECT ... WHERE docid % 10 == 1 ... SELECT ... WHERE docid % 10 == 9 -- 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/cb5e8924-dbeb-57c4-853c-6e6a87f2e77e%40gmail.com.