title: What are indexes and how can I use them to optimize queries in my database?
body: <p>I am maintaining a pretty sizable application and database and am noticing some poor database performance in a few of our stored procedures.</p>
  
  <p>I always hear that "adding an index" can be done to help performance. I am certainly no DBA, and I do not understand what indexes are, why they help, and how to create them.</p>
  
  <p>I basically need an indexes 101. </p>
  
  <p>Can anyone give me resources so that I can learn?</p>