advanced performance SQL Server PostgreSQL SQLite
Create a Partial (Filtered) Index
Index only the rows that satisfy a `WHERE` condition using `CREATE INDEX ... WHERE condition`, shrinking the index and speeding up queries that always filter on the same predicate.