I have been advised that adding an index to a table in SQL Server will increase performance in my database when it is queried. I have no doubt that this is true, but I would like to know a way to prove the effectiveness of the index - whether this be a before and after report... I want a way of documenting the effectiveness of an index. Any ideas?
I have tried using a query execution plan, but the results are identical before and after