SQL Practice Logo

SQLPractice Online

Level 6 - ExpertOptimization Questionsm2 performance schema

Optimization: Covering Index Friendly Query

Pick the query that better matches a covering index `(tenant_id, created_at, status)`. Query A: SELECT * FROM events WHERE tenant_id = 42 AND created_at >= '2026-01-01'; Query B: SELECT tenant_id, created_at, status FROM events WHERE tenant_id = 42 AND created_at >= '2026-01-01';