Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from nadeemahmed76 on Oct 26 at 7:22 PM It can be done online even in production environment, but better you carry
out this activity when there will be less load.
Thanks.
| | | ---------------Original Message---------------
From: Andy Murzyn
Sent: Wednesday, October 26, 2016 11:11 AM
Subject: DB02 Update Table Statistics
My FICO analyst has asked me to update the statistics of a number of finance tables, CE12000, VBAP, FAGLFLEXA to just a few. I'm done this in my Sandbox system with no noticeable negative impact. I wouldn't have expected any though considering it's a sandbox system with few active users and even less activity. My question is this:
Does updating these table statistics in Production require downtime or is enough to just perform these operations during a slow time (i.e. Saturday/Sunday)?
Most of the tables I updated completed within a few minutes, but FAGLFLEXA took over an hour.
Any advice is greatly appreciated,
Thank you,
Andy Murzyn |
| Reply to this email to post your response. __.____._ |   _.____.__ |
