Change Update stats job creteria

[Former Member]

Hi ,

As per my understanding Update statistics job Update stats of table if it has been changed more than 50%.

Please suggest where we can check this value set for job and How can we change it.

Regards,

Shivam Mittal

[Former Member · Accepted solution]

Hi Shivam,

You can set the "stats_change_threshold" parameter, in "init<DBSID>.sap" file. Check http://help.sap.com/saphelp_bw30b/helpdata/en/02/0ae0c6395911d5992200508b6b8b11/content.htm

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

Hi Orkun,

Thanks for reply.

We checked that this parameter is commented in our system so it means by default system picks 50% for stats update if parameter is not active also.

Regards,

Shivam

[Former Member · Accepted solution]

Hi Shivam,

>> We checked that this parameter is commented in our system so it means by default system picks 50% for stats update if parameter is not active also.

Yes, you are exactly correct.

Best regards,

Orun Gedik