Level 7 - ArchitectOptimization Questionsm1 indexing strategy
Optimization Showdown: Active Users Lookup
Choose better query and provide final SQL. Query A: SELECT u.user_id, u.email FROM users u LEFT JOIN sessions s ON s.user_id = u.user_id WHERE DATE(s.last_seen_at) = CURRENT_DATE AND u.status = 'ACTIVE'; Query B: SELECT DISTINCT u.user_id, u.email FROM users u JOIN sessions s ON s.user_id = u.user_id WHERE s.last_seen_at >= CURRENT_DATE AND s.last_seen_at < CURRENT_DATE + INTERVAL '1 day' AND u.status = 'ACTIVE';
Schema Context
users(user_id, email, status), sessions(session_id, user_id, last_seen_at)