Partial/Filtered Indexes

← Back to Indexing

Indexes that cover only a subset of rows matching a specified condition. Smaller than full indexes, more efficient for queries targeting specific subsets of data.

Key Properties

• Index a Subset of Rows

---

relational-databases indexing partial-index