Re: [h2] Very slow calculateCost

2016-12-01 Thread Christian MICHON
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

Re: [h2] Very slow calculateCost

2016-12-01 Thread Sergi Vladykin
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