Re: [h2] Poor performance

2015-12-23 Thread James Sheets
Just to be clear, by "covering" I meant an index that covers the predicate and the projection. -- 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+unsubs

Re: [h2] Poor performance

2015-12-23 Thread James Sheets
Yes, but there's a very large real-world performance difference between using the index I've created and the unique key that H2 chooses. I don't know anything about the internals of H2, but I could make some guesses as to why. I personally think the most intuitive behavior would be to use a c