Question Re: Statistics are missing for TABLE in Technology Q&A

Statistics are missing for TABLE

Ganimede-Dignan — Tue, 23 Dec 2014 09:22:06 GMT

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.

Re: Statistics are missing for TABLE

Ganimede-Dignan — Tue, 23 Dec 2014 09:30:43 GMT

Re: Statistics are missing for TABLE

former_member187136 — Tue, 23 Dec 2014 10:06:30 GMT

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