SQL Practice Logo

SQLPractice Online

Level 6 - ExpertOptimization Questionsm2 performance schema

Optimization: Sargable Status Filter

Choose the better filter for index usage on `(status, updated_at)`. Query A: SELECT id FROM jobs WHERE UPPER(status) = 'FAILED'; Query B: SELECT id FROM jobs WHERE status = 'FAILED';