A partial index is built with a WHERE clause and contains only matching rows. Combined with UNIQUE it enforces rules such as “at most one open order per customer” while allowing many rows with other statuses.