Also, please see https://github.com/h2database/h2database/issues/701 — an index is never used for ordering, when DESC is requested. The latter isn't quite that easy to fix, as it requires understanding of how TableFilter, IndexCondition, IndexCursor and such are set up.
On Wednesday, December 27, 2017 at 1:32:15 PM UTC+1, hendrik wrote: > > Wasn't quite as east as I first thought, bu the PR is > https://github.com/h2database/h2database/pull/700 > > On Saturday, December 23, 2017 at 1:42:10 PM UTC+1, hendrik wrote: >> >> I'll see what I can do. Might take a little while—you know, holidays and >> such... >> >> On Saturday, December 23, 2017 at 1:30:59 PM UTC+1, Noel Grandin wrote: >>> >>> that sounds like an improvement, would you like to submit a PR? Perhaps >>> with a test-case? >>> the TestOptimisations class has a bunch of tests for this kind of thing. >>> >>> >> -- 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 post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
