Statistics are missing for TABLE

[Ganimede-Dignan]

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.

[Ganimede-Dignan]

[former_member187136]

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