Issue:
You would like to know how to check database statistics last updated date/time & percent rows modified in tables of your SAP Sybase ASE Environment.
Resolution:
The statistics are stored in the system tables systabstats and sysstatistics.
isql -Usa -SASETST -X -w4000
password:
>use TST
>go
>select id, moddate, datachange ("emp", NULL, NULL) as datachange from ..sysstatistics where id=object_id("emp")
>go
Note that the "datachange" column result is expressed in percentage, it is based on the number of rows remaining after a change.
For example, if a table has five rows and one row is deleted, datachange reports a value of 25 % since the current row count is 4 and the datachange counter is 1.
No comments:
Post a Comment