Posting balances to a different table

I'm kinda a newbie to Oracle. I'm trying to Post Account balances for a transaction table to a Posting table. I was hoping that it would speed up the querying of the Transaction table, but found out that it makes no difference.

I use a function to query the Transaction table for a specific Account's balance at a specific date. The function first checks for that Date and Account in the Posting table, then queries the remaining transactions from the Transaction table to get the balance. Is there a way to speed up this Querying? With one years worth of transactions it takes about a second per Account to get the balance. In about 5 years time I'm afraid it would be too slow to use.

If anyone has some suggestions, please let me know.

Thanks,
Mark Received on Mon Feb 23 2004 - 14:59:34 CST