Glossary: PostgreSQL for Developers
partial index
An index with a WHERE clause that covers only some rows, so it stays small and serves queries with the same WHERE.
Glossary: PostgreSQL for Developers
An index with a WHERE clause that covers only some rows, so it stays small and serves queries with the same WHERE.