Report Index creation time and modification time
Every 'first class' object in SQL Server has a creation time and a modification time as listed in sys.objects.createdate and sys.objects.modifydate.
Why do indexes not have a create or modify date?? Seems like such a simple feature, how has it been missed all these years?
Even new features (i.e. XML SCHEMA COLLECTION) has a create and modify date. Indexes have been around since the begining of time! Let's get this added.
The only half way workaround is to query STATS_TIME, but this only gives the LAST time that stats were created for this index. It will NOT give index creation time.
Upvotes: 2<=-=Mar 30 2010 6:12PM=-=>
Thanks for your suggestion. For now, the work around is to create DDL trigger and track the index creation/alter in your own tables. This will allow you to get the information you are looking for.
I will mark this item as closed as there is already an item with connect-id (feedback-id) 394870