Glossary: PostgreSQL Beyond the Basics
Partial index
An index with a `WHERE` condition that covers only some rows, such as Alex's 463 `processing` orders. It is much smaller and is used only when the query includes the same condition.
Glossary: PostgreSQL Beyond the Basics
An index with a `WHERE` condition that covers only some rows, such as Alex's 463 `processing` orders. It is much smaller and is used only when the query includes the same condition.