Partial index

In databases, a partial index, also known as filtered index is an index which has some condition applied to it so that it includes a subset of rows in the table.

This allows the index to remain small, even though the table may be rather large, and have extreme selectivity.