Hello! H2 is unable to optimize such OR conditions when multiple columns are involved.
To make your query faster, you need to rewrite it with a UNION between two inner queries, one with filtration by first column and second with filtration by second one. These inner queries should be able to use indexes on these columns. -- 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/2d90abe8-3ee5-441c-a695-bc1f7ec28de8n%40googlegroups.com.
