Skip to content

Glossary: PostgreSQL Beyond the Basics

Expression index

Also written: index on an expression, lower(email) index

An index built on a function's result, such as `(lower(email))`. The query's WHERE must use the same expression for the planner to use it.

Where the book teaches it

Related terms

SargableB-tree