I tried updating to the last stabel version (1.2.142) but still have the same error.
I think the problem must have to do with the indexes. How can I get more info on whether and how the indexes are used (i.e. more than using EXPLAIN ANALYZE) and perhaps info about the index itself? Thanks, Dario On Fri, Sep 24, 2010 at 10:58 AM, Dario Simone <[email protected]> wrote: > I forgot to mention: > > I'm using version 1.2.139 > > On Fri, Sep 24, 2010 at 10:15 AM, Dario <[email protected]> wrote: >> Hi all, >> >> All in all I'm really happy with H2 and (almost) everything works as >> it should. >> >> While looking at a query, with bad performance I came upon strange >> behaviour, though: >> H2 didn't use the primary key index to do a join which had only the >> table's primary key in the on-clause (explain showed a scanCount for >> that join of 106757553). After dropping the Index and recreating the >> primary key, the index was used (the scanCount was down to 35003). >> >> The only difference in the index before and after the recreation is, >> that the one before had IS_GENERATED = true and the one after had >> IS_GENERATED = false. >> >> It seems as if the index was there and if I understand the explain >> syntax correctly the optimiser decided to use it, but then scanned the >> whole table anyways in spite of the existing Index. >> >> Has somebody come across such a behaviour before? >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/h2-database?hl=en. >> >> > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
