40 ms·
Postgres absolutely adds nulls to its indexes. You can even control how they are ordered, and on the last few versions if nulls are equal or not. A complete in
by marcosdumay 4y ago
Postgres absolutely adds nulls to its indexes. You can even control how they are ordered, and on the last few versions if nulls are equal or not.
A complete index over a column will have entries for all records, and can be used on "x is null" and "x is not null" filters.