The index that was ignored
There is an index on students.email. This query does not use it:
sql
SELECT * FROM students WHERE LOWER(email) = '[email protected]';
Why?
There is an index on students.email. This query does not use it:
sql
SELECT * FROM students WHERE LOWER(email) = '[email protected]';
Why?