Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Posting balances to a different table
Mark,
Have you looked at materialized views for this?
Doug Windham
"Mark" <dontmarkdueckspam_at_hotmail.com> wrote in message
news:736c4042f301b3d619b3cd43753b722c_at_news.teranews.com...
> 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 - 15:35:44 CST