Select * from sys.dm_db_missing_index_details
Due to huge data existing in specific tables, it requires a more frequency of data access.
Contact your DBA for further analysis.
Missing indexes can be added to the ARS DB tables. Indexes improve read speeds for the queries they cover, but they can also slow down writes on those columns. Any insert, delete, or update that touches columns in an index will also need to update the index with whatever change was made.
See below sample scenario:
1.- Add new non clustered index to the dbo.ACEs with name:
2.- Select “Columns” [edsaAccessTemplateGUID], [edsaTrusteeSID], [edsaSecObjectGUID] in the tab “Index key Columns”:
3.- Select Columns [objectGUID],[name],[distinguishedName], [objectClass],[isDeleted] in the tab “Included columns”: