Hi, I have two tables like: create table master ( id identity primary key, filepath varchar, repository varchar, user varchar, comment clob) create table details ( id identity primary key, filepath varchar, repository varchar, action varchar, modified timestamp) alter table details add foreign key (filepath, repository) REFERENCES master (filepath, repository)
If I execute below query: SELECT details.id, details.filepath, details.repository, details.action, master.user, master.comment FROM details, master WHERE details.filepath = master.filepath and details.repository=master.repository LIMIT 50 H2 handles very perfect, but if I add some order by to the query, for example, order by details.action, master.user, the query becomes very slow although I have already created the index for both details.action and master.user. I run the test with h2 1.3.150 and use embedded mode. Can anybody help me ? -- 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.
