medium10 pts · first answer countsdatabasesindexespostgresql

Case-insensitive lookup ignores the index

Login runs `WHERE lower(email) = lower($1)` and is slow, though email has an index. What fixes it in PostgreSQL?

A.Add a second index on emailB.Use LIKE instead of =C.Run VACUUM FULL on the tableD.Create an index on lower(email)

Discussion 0

Join free to post in the discussion.