Expression index

sql

CREATE INDEX idx_users_lower_email ON users ((lower(email)));

Explanation

Expression indexes help when the query applies a function such as `lower(email)`.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing PostgreSQL index types

Default choice for equality, ranges, and ordering.

Open In sheetsqlsame section

Speed containment queries on JSONB data.

Open In sheetsqlsame section

Use BRIN when physical order correlates with query ranges.

Open In sheetsqlsame section

Index only the rows a hot query actually needs.

Open In sheetsqlsame section

Reduce blocking on busy tables.

Open In sheetsqlsame section

Inspect actual execution behavior.

Open In sheetsql1 tag match