Answer
MySQL uses composite indexes left-to-right. If the first column is not used in filtering, the index cannot be used efficiently.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ