title: How do MySQL indexes work?
body: <p>I am really interested in how MySQL indexes work, more specifically, how can they return the data requested without scanning the entire table?</p>
  
  <p>It's off-topic, I know, but if there is someone who could explain this to me in detail, I would be very, very thankful.</p>