Index a Subset of Rows

← Back to Partial Filtered Indexes

Partial indexes only index rows matching a WHERE condition, resulting in smaller indexes that are faster to maintain and scan for targeted queries.

relational-databases indexing partial-index