SQL Practice Logo

SQLPractice Online

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';