Ron Johnson did a very nice and very concise introduction to index performance and analysis that is very worth your time.  It is only an introduction but could still help someone out there fighting an index performance problem.

If you’re not a member of SQLServerCentral.com, it’s quick, easy and free to sign up so don’t let that deter you from reading the article!

Happy Coding!