> there's no problem splitting dates with triggers if you want to.
> I use group by on non-split dates and do not experience any performance
> issues. So I'm not sure what your issues here are.
> Alan
>
> Thanks Alan.
> And how do you do to group by by the month in the date? Or by the day in
> the date?

Here's an example
SELECT EXTRACT(YEAR FROM FORECASTDATE) FORECASTYEAR,
EXTRACT(MONTH FROM FORECASTDATE) FORECASTMONTH, sum(LOAN_AMT) LOAN_AMT,
SUM(COMMISSION) COMMISSION, SUM(FEEPAID) FEEPAID FROM TABLENAME
GROUP BY 1, 2

Alan