Dick Kniep <dick@kniep.nl> writes:
> Does this also affect if you have many NULL values in the key? So testing Not
> is NULL would also be affected?
IS NOT NULL isn't an indexable operation, so your question doesn't really
apply :-(
regards, tom lane