title: What are the biggest benefits of using INDEXES in mysql?
body: <p>I know I need to have a primary key set, and to set anything that should be unique as a unique key, but what is an INDEX and how do I use them?</p>
  
  <p>What are the benefits? Pros &amp; Cons? I notice I can either use them or not, when should I?</p>