Dick Kniep <dick@xxxxxxxx> 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