About Me

Barking, Essex, United Kingdom
MCITP DBA ,MCITP BI & Oracle OCP 11G

Monday, August 4, 2014

Get index creation Date


Select Name as IndexName,
STATS_DATE ( object_id , index_id ) as IndexCreatedDate

From sys.indexes where object_id=object_id('dbo.datagathering')

No comments:

Post a Comment