Optimization Showdown: Function Index Trade-Off

Choose better query shape and provide final SQL. Query A: SELECT user_id FROM users WHERE LOWER(email) = LOWER('ops@acme.com'); Query B: SELECT user_id FROM users WHERE email_normalized = 'ops@acme.com';

users(user_id, email, email_normalized)