0votes
1 answersWhat column order should a MySQL composite index use for filtering and sorting?
A questions query filters by `authorId`, sorts by `createdAt DESC`, and returns 20 rows. Would an index on `(authorId, createdAt)` help? Would the same index be equally u