When using the stable 1.3.176 my query, which has 7 tables to join returns pretty fast.
After upgrading to the 1.4.191 I see my query returning in 20 to 40 times longer. This came from the Optimizer which decided that even for 7 joins all plans should be tested using brute force. These setting are unfortunately not configurable. I played a bit making them configurable and that made my query return in a decent time again. Are there plans to making these brute force and genetic settings of the Optimizer configurable? Thanx, --Ivo -- 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 post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
