What is a partial (filtered) index and when is it a big win?

Answer preview

A partial (filtered) index indexes only the rows matching a WHERE predicate in its definition. It is the standard fix for a skewed column: index the 0.5% of rows you actually query and ignore the 99.5% you never touch.…