Hi, EXPLAIN ANALYZE:
SELECT COUNT(*), SUM(CONVERT(AFLAG,INTEGER)) AS CNTAFLAG FROM Test1 THIS_ /* FKC3BE9D399BE4559C_INDEX_A: fk_test2 = 22741 */ /* scanCount: 76246 */ WHERE THIS_.fk_test2 = 22741 /* total: 76433 Test1.FKC3BE9D399BE4559C_INDEX_A read: 559 (0%) Test1.Test1_DATA read: 75874 (99%) */ Test1 contains only one VARCHAR(255) column, all the other columns are either INTEGER(10) OR BOOLEAN(1) Regards, Peter On Jun 22, 8:45 pm, Thomas Mueller <[email protected]> wrote: > 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 alsohttp://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.
