Can you please share the database with H2 community?
It's hard to tell what is happening without a concrete dataset or at least the
complete DDL.
Please do so if the above suggested solution does not work for you.
--
You received this message because you are subscribed to the Google Groups "H2
Hi!
If you know correct join order for tables in your query, you can enable
setting FORCE_JOIN_ORDER on you connection. This way H2 optimizer will not
try to find the optimal join order, but will just find the best indexes for
the join order as it is written in query. It will be much faster.
Anot