Thanks @Evgenij for the suggestion.. Will try the same. Regards, RDS
On Friday, 17 February 2023 at 18:20:47 UTC-8 Evgenij Ryazanov wrote: > 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/35ff5f03-c077-410d-a080-b757e7ec317bn%40googlegroups.com.
