cancel
Showing results for 
Search instead for 
Did you mean: 

DB13-Frequence for Scheduling Job 'Update statistics'

Former Member
0 Kudos

Dears,

Currently we sheduled job 'Update statistics' in DB13 for our SAP production system  on every Sunday,

I don't know is it enough ? Do we need run it for everyday ?

Before there is a talble(NAST) accessing speed is very slowly in PRD but very fast in QAS system,

I checked update statistics job is scheduled in QAS on everyday, but I think the result is same as run the job in PRD system on every Sunday.

Now there is another table(VBOX) in PRD system is also accessing very slowly but in QAS system is very fast, is it related with the frequency of job 'Update statistics' ?

Thanks,

Michael

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi

if database is large then Recommendation is Once a week .

and yes indeed Update statistics will improve the performance.but again when we speak of performance it is also depend or Hardware and IO operation on server.

Regards

Dishant

Former Member
0 Kudos

Hi MIchael,

Yes update statistics on frequent run will improve the performance.

No sure you are on which DB if on DB2 there is one parameter

Automatic runstats                  (AUTO_RUNSTATS) = ON

which triggers runstats as soon as table catalog gets updated/modify.

Hope it helps

BR Vaibhav

Former Member
0 Kudos

Hello,

updating statistics is a procedure for preparing some information about the database and it increases performance of the database.

It is good to have these statistics actual, but it still doesn't mean you have to run this job all the time one by one. By the way it can take several hours to perform this job. And during the run it can even slow down the system.

So in my opinion, in productive system weekly schedule is enough and choice of weekend for it was decision. And you can think about if it is needed in quality system to run update every day. I think it is not worth it.

Kind regards

ACE-SAP
Active Contributor
0 Kudos

Hello

Since 10g SAP recommends to schedule statistics daily. With such frequency the statistic update should be quick. Statistics are only updated for a table if the changes made to that table  are over STATS_CHANGE_THRESHOLD threshold.

Regards

106047 - DB21: Customizing the DBSTATC

BRCONNECT determines whether statistics are necessary, taking into account the number of table entries compared to the number of the table entries during the last statistics creation. If the variance exceeds a threshold value (default: stats_change_threshold = 50%), new statistics are created.

588668 - FAQ: Database statistics

12. How should statistics usually be created?

To keep the statistics up-to-date, we recommend that you schedule the following at least once weekly (Oracle 9i or lower) or at least once daily (Oracle 10g or higher):

divyanshu_srivastava3
Active Contributor
0 Kudos

Hi Michael,

Read this

We recommend you to schedule this action every week, preferably at a time when the database is not under heavy load. It might take several hours to complete and can significantly load the system

And it comes from : http://help.sap.com/saphelp_nw73/helpdata/en/45/d59d85b3735594e10000000a1553f7/content.htm

Update Statistics - SAP Database Guide: Oracle - SAP Library

So, just go through above link and check how you can work on single tables too.

YES, Update statistics improves performance.