[Helma-user] allowing NULL VALUES in foreign keys

[nighthawk]

On 8/20/06, Julian Tree <julian.tree at gmail.com> wrote:
> [...] I was told
> to NOT allow NULL values in any database columns, because it prevents
> the column from beingporperly  indexed.
[...]
> How are everyone's handling NULL values on a foreign key? Is NOT NULL
> column really unindexable? or am I worrying over nothing.  I am using
> postgresql 8.1.x, BTW.

I am using Postgresql (8.0 tho) at work aswell and during all the
performance measuring/tuning I did I never noticed what you described.
Where did you hear that columns with NULL values do not get indexed
properly?

+n