sys.dm_db_index_usage_stats:- Maintains counts for the range of index activity and the last performed time. Also displays statistics ob how an index is used against a query.

sys.dm_db_missing_index_details:- Returns detailed information about each missing index on a table. Information is lost at SQL Server recycle.

sys.dm_db_missing_index_columns:- Returns information about database table columns that are missing an index, excluding spatial indexes.

sys.dm_exec_query_stats:- Performance statistics for cached plans. The information is only available while the plan remains in the cache. 

sys.dm_db_index_operational_stats:- Returning IO, locking, latching and access activity. Useful for identifying index hotspots, waits for read\writes to a table. Will give information about insert,update, and delete