“Actually, if you’re using MySQL, keep in mind that it never uses more than one index per table, so if you’re always selecting on two or more columns in a certain table, you’re better off having a single multi-column index.”
— Somebody on DB indexing in RoR 4 years ago
