Hi Experts, Please let me know the query to list the all the indexes which are user defined in the last 5 years, as there are so many indexes on application level just i am looking for the indexes which are added manually from backend at database level. Thanks in advance
There is no way to get the date created for an index other than a Primary Key or Unique key as those two are constraints and will have a record in sys.objects. sys.indexes doesn't have a creation column so you will need to write an routine which recognizes CREATE INDEX commands and creates a log going forward. There is also no way to differentiate an index created by a user or by the application.