PDA

View Full Version : Design considerations of column nullability

red
03-22-02, 04:31
Personally, I try set all columns NOT null whenever possible.

Any other ideas ?
MattR
03-22-02, 13:34
Design to what your data dictates, although in most RDBMS's there is a slight performance and size advantage to NOT NULL, so I design NOT NULL where I can and only in certain cirucmstances do I use NULL.
alexiville
06-11-02, 01:14
What would you suggest for a datetime field where the value is not known and should therefore be not-applicable?
MattR
06-11-02, 10:27
NULL sounds good to me.