We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

[sap-basis] DB02 Update Table Statistics

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Question from Andy Murzyn on Oct 26 at 11:06 AM
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.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
© 2016 Ziff Davis, LLC. and message author.
Ziff Davis, LLC. 28 E 28th Street New York, NY 10016
Andy Murzyn  

achievements
 
View this online
Ask a new question
 
In the Spotlight
Become a blogger at Toolbox.com and share your expertise with the community. Start today.

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language