SQL Server index help performance?

Question

I have run the Database Engines Tuning Advisor in Sql Server 2008 R2, then there are a few indexes that it suggested me to create, so I created them. The question is, in what way that I can check if these indexes are helping the DB performance ? Thank you.

Answer 1

Try running an explain plan on the queries that are performed in your application. They should show a relatively low query cost.

You could drop the indexes again, run the original explain plan statements to compare the performance before and after adding the index.