Wednesday, March 7, 2012

is there any way ( table ) to find out when last time statistics got updated for

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

No comments:

Post a Comment