Partial and Expression Indexes
Learn to create indexes on a subset of rows or on the result of an expression for targeted optimization.
Intro to Targeted Indexes
Welcome! In this lesson, we'll dive into two powerful, specialized index types in PostgreSQL: Partial Indexes and Expression Indexes.
These indexes allow for highly targeted optimization, focusing on specific subsets of data or the results of calculations, rather than entire columns.
Focus with Partial Indexes
A Partial Index is an index that covers only a portion of the rows in a table. You define this subset using a WHERE clause during index creation.
Think of it as filtering your index. Only rows that satisfy the WHERE condition will be included in the index structure.
All lessons in this course
- Hash, GIN, and GiST Indexes
- Partial and Expression Indexes
- Covering Indexes and Index-Only Scans
- BRIN Indexes for Large Sequential Data