Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Table statistics / index statistics generation

Hi,

How often do you run/should system run table & index statistics through DBA calendar/BRtool? What impact on system load does it have? Do you run it for all tables & indecies above certain size?

Thank you,

Mike

Former Member
Former Member replied

Hai,

It is better to run update statistics in your systems every week to get the Table statistics new.

By running update statistics regularly, you make sure that the database statistics are up-to-date, so improving database performance. You can schedule the checks in the Computing Center Management System of the SAP System, using the DBA Planning Calendar.

The Oracle cost-based optimizer (CBO) uses the statistics to optimize access paths when retrieving data for queries. If the statistics are out-of-date, the CBO might generate inappropriate access paths using the wrong index, resulting in poor performance.

It is better to run it when the load on the system is low, i.e., on Saturdays or Sundays.

You should run on all Tables.

http://help.sap.com/saphelp_nw04/helpdata/en/9f/b2503e30a9d549e10000000a114084/frameset.htm

Regards,

Yoganand.V

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question