mediumSQLcomposite and partial indexesSingle-choice MCQ

You have a composite index on (status, created_at). Why might 'ORDER BY created_at' for a single status be served without a sort step?

SELECT * FROM jobs WHERE status = 'queued' ORDER BY created_at;