Hi, > ( index used)
How did you verify the index is used? Could you post the result of "EXPLAIN ANALYZE SELECT ..."? Could you also post the CREATE TABLE statement for this table? If the table has large column (large VARCHAR columns) then this might be the reason (use BLOB instead). See also http://h2database.com/html/performance.html 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.
