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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/cb5e8924-dbeb-57c4-853c-6e6a87f2e77e%40gmail.com.
