Is it possible to define/ create aggregate tables which store monthly or yearly totals. So that it doesn't take any time to calculate these totals.
I am asking about table as i think a view would still take time to calculate.
Aman
-------
Lets fly away to the Land where there is Love & Peace