Skip to Content
avatar image
Former Member

upgrade statistics

From  long some tables are not statistics updated?how to  update statistics in ms sql server 2008 through sap application? I checked in  Db02-database options-statistics are active?but some tables are not updating ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Feb 04, 2014 at 12:00 PM

    Hi Visu,

    In SAP system go to DB20 and give table name in the field and use menu option.

    goto Statistics->Create statistics

    This will update the statistics to latest in your system

    Hope this helps.

    Regards,

    Deepak Kori

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 04, 2014 at 11:45 AM

    To update individual table statistics you can use the Tx DB02.

    I am not sure whether it will work on an SAP system running on MSSQL.

    Regards

    RB

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 04, 2014 at 04:03 PM

    Hello Visu,

    The row modification counter is used on table and index level. If a lot of data are changed, the automatic update statistics is executed more frequently.

    The following links could be useful:

    http://support.microsoft.com/kb/195565/en-us

    http://msdn.microsoft.com/en-us/library/ms181055.aspx

    Regards,

    Eduardo Rezende

    Add comment
    10|10000 characters needed characters exceeded