Skip to content

Glossary: PostgreSQL Beyond the Basics

Multicolumn index

Also written: composite index

An index on several columns, where order matters. Put columns tested with `=` first and the sort or range column last.

Where the book teaches it

Related terms

B-treePartial index