on 05-16-2008 6:22 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.