You can also write this query it to tell you what are the missing indexes

This will work only on db witch people working and apps are sending queries to this db

select * from sys.dm_db_missing_index_details