SQL Practice Logo

SQLPractice Online

Level 7 - ArchitectDebugging Questionsm1 indexing strategy

Debug Non-Sargable Email Lookup

Find and fix performance issue: SELECT * FROM users WHERE UPPER(email) = UPPER('alice@acme.com') AND created_at::date = CURRENT_DATE;

Schema Context

users(user_id, email, created_at, status)