CREATE INDEX idx_user_email ON users(email); EXPLAIN SELECT * FROM users WHERE email = "test@example.com"; ANALYZE TABLE users;