I am really interested in how MySQL indexes work, more specifically, how can they return the data requested without scanning the entire table?
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.
