Level 9 - DistinguishedOptimization Questionsm2 storage index mvcc internals
Optimization: Function Index vs Plain Predicate
Choose better query for index usage on email lookups. Query A: SELECT user_id FROM users WHERE LOWER(email) = 'ana@example.com'; Query B: SELECT user_id FROM users WHERE email = 'ana@example.com';