Regarding PA2001 table problem

[Former Member]

HI Frds,

I have got problem from HR user that when there are updating leaves its very slow in update table PA2001. I dont know what to do for this ? I have checked the size of table its 95000 -> 380000 and current records in this table is 376038

So doesit mean that because records table updation happens slow ? Kindly guide what to do in this case ?

Regds,

Deepak

[former_member204746 · Accepted solution]

a few possibilities:

1. recalc db stats:

brconnect -c -u / -f stats -t PA2001

2. rebuild indexes of PA2001

brconnect -c -u / -f idrebuild -i "PA2001*"

good luck.