How to check database statistics last update date time in Sybase database
Sybase ASE 0
(0)
Below query can be used to check when was last update stats run on the database.
use DBNAME
go
select SUBSTRING(@@servername,1,20) 'Server_Name',db_name() 'DB_Name', SUBSTRING(object_name(id),1,30) 'table_name',statmoddate from systabstats where id=object_id('tablename') and indid=0
Sample output:

How useful was this post?
Click on a star to rate it!
Average rating 0 / 5. Vote count: 0
No votes so far! Be the first to rate this post.