Skip to Content

Statistics are missing for TABLE

Hi,

in a sendbox system, migrated from Oracle to ASE from few days, I've already setup  ATM but on DBACOCKPIT -> Diagnostic -> Table statistics there are several tables with "Statistics are missing for ..."

Is it correct? How can I calculate statistics for this tables?

Summary Number of Tables with Incomplete Index Statistics: 20.230 Number of Tables with Sticky Statistics: 1.309

Thank you so much.

Regards.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 23, 2014 at 09:30 AM


    Add comment
    10|10000 characters needed characters exceeded

    • Hello Ganimeda,

      Please use the below SAP note to update the index statistics which are reported as missing from your report.

      1757691 - SYB: How to manually update index statistics of a table using isql



      Regards

      Kiran Kumar A

      SAP