SQL Arena
#986

Case-Insensitive Login

The login form searches by email regardless of letter case, and a plain index on email does not support that pattern. Create an index on the normalized email value used by login.

Speed this query up with an index
CREATE INDEX ix_users_lower_email ON users (lower(email))

Tik CREATE/ALTER/DROP — galutinio SELECT nereikia.

Prisijunkite, kad pateiktumėte

Jūsų užklausos rezultatas bus rodomas čia