Thanks for the article. How do you assess when is a good time to create another index for

SELECT * FROM sakila.customer WHERE last_name='WILLIAMS' AND first_name != 'LINDA'?

Do you create 2 indexes?

index(last_name, first_name)

index(first_name, last_name)