Hi, Thank you for your answer.
I have indexes on both of my tables. Here is the sql creation indexes for the table entity : CREATE PRIMARY KEY PUBLIC.PRIMARY_KEY_7A ON PUBLIC.ENTITY(ID) CREATE INDEX PUBLIC.NAMEONLYIDX ON PUBLIC.ENTITY(ENTITYNAME) CREATE INDEX PUBLIC.NAMEIDX ON PUBLIC.ENTITY(ELEMENTTYPE, ENTITYNAME) CREATE INDEX PUBLIC.FULLIDX ON PUBLIC.ENTITY(GID) And the indexes of my second table (ENTITYSTATE) : CREATE PRIMARY KEY PUBLIC.PRIMARY_KEY_C ON PUBLIC.ENTITYSTATE(ID) CREATE INDEX PUBLIC.DATEIDX ON PUBLIC.ENTITYSTATE(TIMESTAMP) Regards, Quentin On 13 nov, 09:17, Thomas Mueller <[email protected]> wrote: > Hi, > > Do you have indexes on these tables? > > > > Yes, I would ask the same question. > > Regards, > Thomas -- 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.
