Hello All,
is there any way ( table ) to find out when last time statistics got updated for a table ? ( using script)
thank you
jagdishUSE [YOUR DATABASE]
SELECT 'Index Name' = i.name,
'Statistics Date' = STATS_DATE(i.id, i.indid)
FROM sysobjects o, sysindexes i
WHERE o.name = 'employee' AND o.id = i.id
GO
or
STATS_DATE ( table_id , index_id )
table_id
Is the ID of the table used.
index_id
Is the ID of the index used.
;)|||Thank you very much
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment