My simplified select statement: select count(*), SUM(CONVERT(aFlag,INT)) from Test1 where fk_test2=999 Test1 has about 30 columns fk_test2 is a foreign key ( index used)
Table Test1 has about 6,000,000 rows. count(*) = 70,000 The first time i execute the statement it takes 90000ms The second time 9000ms, and then 900ms Is it possible to reduce the first execution time? How does the cache work? I have not found a detailed description. Regards -- 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.
