Hi Thomas I tried your suggestion; these are results: *1) explain select count(ID) as y, HDR_EVENT_NUMBER as text from XDASV1 GROUP BY HDR_EVENT_NUMBER;*
Result: *PLAN * *SELECT* * COUNT(ID) AS Y,* * HDR_EVENT_NUMBER AS TEXT* *FROM PUBLIC.XDASV1* * /* PUBLIC.XDASV1.tableScan */* *GROUP BY HDR_EVENT_NUMBER* *2) explain ANALYZE select count(ID) as y, HDR_EVENT_NUMBER as text from XDASV1 GROUP BY HDR_EVENT_NUMBER;* Result: *PLAN * *SELECT* * COUNT(ID) AS Y,* * HDR_EVENT_NUMBER AS TEXT* *FROM PUBLIC.XDASV1* * /* PUBLIC.XDASV1.tableScan */* * /* scanCount: 406527 */* *GROUP BY HDR_EVENT_NUMBER* */** *total: 255747* *XDASV1.XDASV1_DATA read: 255331 (99%)* *overflow read: 416 (0%)* **/* While this is the index I have on HDR_EVENT_NUMBER: *CREATE INDEX IF NOT EXISTS CMP_AUDIT_EVTNBR_IDX ON XDASV1(HDR_EVENT_NUMBER);* Do you have any other suggestion/idea? Thank you Angelo Il giorno 28 ottobre 2011 09:21, Thomas Mueller < [email protected]> ha scritto: > Hi, > > And how does the plan look like (explain analyze)? > http://h2database.com/html/performance.html#explain_plan > > 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. > > -- 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.
