How to get required 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.