ColumnIndexOptions.predicate property

Restricts the index to the rows this SQL condition matches.

Signature:

predicate: string;

Remarks

A partial index: smaller and cheaper to maintain, and used only where the planner can prove a query's own condition implies this one. Raw SQL, emitted as written, so the quoting is yours to get right.