On Fri, Mar 28, 2025 at 10:02 AM David G. Johnston < david.g.johns...@gmail.com> wrote:
> Selectivity is evaluating cardinality with an eye on the frequency of > the values you are actually going to be filtering on. So low cardinality > booleans can be highly selective in usage if you are looking for the rare > false in a sea of trues but low selectivity if looking through those trues. > And to accommodate the highly-selective case a partial index is much better than indexing the low cardinality boolean column values. David J.
