Hi there, does anyone has an optimal way of calculating the
month-to-date and year-to-date balances for a datawarehouse, based on
a huge number of ledger journal lines? My customer, an international
bank, is on 9.2.0.5. I already tried the 9i OVER (PARTITION BY ...)
stuff but am unable to place this kind of query in fast refresh MV's;
it wont take complex SQL for fast refresh. Complete refresh is not an
option due to performance constraints.
I also tried regular PL/SQL loops, but the performance sucks. I wonder
if this can be done with PIPED FUNCTIONS but have trouble getting the
logic right, as we do not use object types in the database.
Any help would be appreciated,
Paul
Received on Wed Jun 16 2004 - 16:45:34 CDT
