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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/35ff5f03-c077-410d-a080-b757e7ec317bn%40googlegroups.com.
