Namecheap interview question

How the MySQL index works?