River interview question

How do SQL indices work?