Procedure takes too long to execute
There is a procedure here which takes huge amount of time to execute.
Previously the same procedure used to run very very fast.
Any help on this will be appreciated.
What this procedure does is:
This procedure is run on the balance table of a bank.
This balance table has a record of all accounts that carries out transactions.
Suppose there are 1000 accounts that has done transaction on 15-may-2009 then this table has
1000 records with date 15-may-2009.
amount of transactions done each day varies:
for eg:
05-may = 20,000 accounts
06-may = 3,000 accounts
07-may = 50,000 accounts
08-may = 7,000 accounts
Suppose an account 'abc' has done transaction on 15-may, 20-may and 25-may, then ABC
Any help on this will be appreciated.
What this procedure does is:
This procedure is run on the balance table of a bank.
This balance table has a record of all accounts that carries out transactions.
Suppose there are 1000 accounts that has done transaction on 15-may-2009 then this table has
1000 records with date 15-may-2009.
amount of transactions done each day varies:
for eg:
05-may = 20,000 accounts
06-may = 3,000 accounts
07-may = 50,000 accounts
08-may = 7,000 accounts
Suppose an account 'abc' has done transaction on 15-may, 20-may and 25-may, then ABC
0