Index a computed expression used in the query.
Section: SQLite index creation
Expression index
sql
sql
CREATE INDEX idx_users_lower_email ON users (lower(email));Explanation
Helpful when the query uses the same expression in predicates.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing SQLite index creation