Get events by date

select distinct date(A.TSTAMP) as DATES, count(A.TSTAMP) as HITS from EVENTS A, EPIC_CHRONICLES B where A.EVENTID = B.EVENTID group by DATES;

Runs very slowly at customer.