How to get required index in SQL Server table

This blog shows you to get required Nonclustered index in sql server table

This blog shows you to find required indexes in sql server. Now I am explaining the following steps in SQL Server.

First of all open a new query window and write your query.

Then click on the button "Display estimated execution plan" like below-

If index not required then it returns like-

If index required then it returns like - 

After getting an index just right click on the green line like - 

Then click on "Missing index details" then open new query window like - 

Now execute this index.

With above procedure we can easily find indexes.

Thank for reading.