LeanTaaS interview question

How do SQL indexes on multiple fields work?