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)