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))
Tikai CREATE/ALTER/DROP — noslēdzošais SELECT nav nepieciešams.
Pieslēdzies, lai redzētu iesniegumu vēsturi
PieslēgtiesPieslēdzies, lai izmantotu AI mentoru
Pieslēgties