Is there a way to clear the missing index usage views.
We worked during last period on index tuning, adding new indexes ,removing duplicate and unused ones.
I need to clear sys.dm_db_missing_index_group_stats ,
sys.dm_db_missing_index_groups and sys.dm_db_missing_index_details
without having to restart SQL server process and without affecting caching on server becuase it will be done on live enviroment.
Thanks in advance and looking forward for ur replies.