Partial Index
A partial index carries a WHERE clause and indexes only the matching rows, e.g. WHERE status = 'pending' on a table that is 99% completed rows. It is smaller and cheaper to maintain than a full index, but the planner uses it only when it can prove the query's predicate implies the index's predicate.
This Concept is waiting for its first lesson!
A partial index carries a WHERE clause and indexes only the matching rows, e.g. WHERE status = 'pending' on a table that is 99% completed rows. It is smaller and cheaper to maintain than a full index, but the planner uses it only when it can prove the query's predicate implies the index's predicate.
Are you a teacher? Sign in to start contributing.
Sign In