Optimization Showdown: Covering Index for Sort + Filter

Choose better index for query WHERE tenant_id=? AND status='OPEN' ORDER BY created_at DESC LIMIT 100. Query A: INDEX(tenant_id) Query B: INDEX(tenant_id, status, created_at DESC)