Hi Angelo
Try doing this:
SELECT
COUNT(HDR_EVENT_NUMBER ) AS Y,
HDR_EVENT_NUMBER AS TEXT
FROM PUBLIC.XDASV1
GROUP BY HDR_EVENT_NUMBER
Regards, Noel.
Angelo Immediata wrote:
> 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]
> <mailto:[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]
> <mailto:[email protected]>.
> To unsubscribe from this group, send email to
> [email protected]
> <mailto:h2-database%[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.
--
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.
