Hi, There are limitations on what the optimizer can do currently.
For really complicated queries, it might make sense if you create a temporary table, then the right indexes, and then use this temp table. Regards, Thomas On Mon, Apr 15, 2013 at 8:58 AM, Noel Grandin <[email protected]> wrote: > > - What version are you testing on? > Would be great if you could test with the nightly build because I made > some index selection improvements recently. > > - What does your DB URL look like? > > - Can you do an EXPLAIN on both variants and post the results here? > > Regards, Noel Grandin > > > -- > 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+unsubscribe@**googlegroups.com<h2-database%[email protected]> > . > To post to this group, send email to [email protected]. > Visit this group at > http://groups.google.com/**group/h2-database?hl=en<http://groups.google.com/group/h2-database?hl=en> > . > For more options, visit > https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> > . > > > -- 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 http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
