LeanTaaS Interview Question

How do SQL indexes on multiple fields work?