What is SQL Server filtered index and how does optimizer leverage it?

Filtered indexes store a subset of rows and improve query performance for selective predicates.

A filtered index includes only rows that satisfy a WHERE condition. This reduces index size, improves cache efficiency, and enhances selectivity. The optimizer can use it when predicates match filter conditions. However, mismatched predicates or implicit conversions prevent usage.