Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 06, 2009 at 05:24 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 06, 2009 at 05:21 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 06, 2009 at 05:30 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 07, 2009 at 12:45 AM

    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

    Add comment
    10|10000 characters needed characters exceeded