On Friday, July 5, 2013 1:09:14 PM UTC+2, Noel Grandin wrote: > > > On 2013-07-05 12:14, Alex wrote: > > > > but even in your case index is used for sorting, isn't it? what about > > > No, it's using the index for searching. > > > where condition is removed , execution time is not decreased. > > > Yeah, complex queries often don't change their time much. > > hm, bad deal, if left join with one small table is complex query for h2.... really, i'm stuck with this problem. i've tried other sql constructions all of them have not reasonable execution time.
thus, i can't see index using, it is most adequate explanation for this problem. is it bug? if yes , will it be fixed? any workaround, suggestion? -- 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. For more options, visit https://groups.google.com/groups/opt_out.
