Posted by David Smithz on 03/04/07 17:44

I have read it is better to always have all the fields in a table set to
NOT NULL as this makes it much quicker.


In one case I have a table where all fields qualify for this accept for one
which is comments. This will only sometimes be filled.

Am I therefore better off making this field still to be Not NULL and set the
default value to a single arbitrary character such as "." or is this
actually making things less efficient.



Input welcomed. Thanks in advance.

[Back to original message]