Table statistics / index statistics generation

[Former Member]

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 · Accepted solution]

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

[former_member603052]

Hi,

You can run Update Optimizer Statistics daily once in the night(i.e when load on database is less & in non peak hours) and u need to select all tablespaces.

Regards,

Kalyan

[former_member182034]

hi Dear,

How often do you run/should system run table & index statistics through DBA calendar/BRtool*S*?

basically we can run with DB13 and if you want to run through BRTOOLS then following steps:

Run --> brtools

select 7

select 1

press C three time

process will be executing the table.

press c // now i m applying

What impact on system load does it have?

it maintain the update and good for health of database...// like.. you don't stable yourseft with out exercise mean it is exercise of datebase

Do you run it for all tables & indecies above certain size?

yea

don't forget the point

regards,

majamil

[Former Member]

Hi,

Which database are you talking about ?

If Oracle, depending from the update load in your database, you usually run the statistics computation every day or every 2 days.

It's usually done with DB13 for all tablespaces because there is first a check and then only the compute for the tables/index for which it is needed.

Regards,

Olivier

[Former Member]

Oracle 10g, 10.2.0.2 specifically