Missing Index in Sql Server

The following query displays required index on sql database.

use databse
go

select *
from sys.dm_db_missing_index_details
where database_id = db_id()