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.