Archives of the TeradataForum
Message Posted: Sat, 20 Apr 2002 @ 17:27:44 GMT
We can dredge up all of the 3 valued logic arguments that have been expounded in the press over the last few years, but in the interest of practicality, let's sum up a few key points.
Nulls always complicate the logic in queries where ever they appear. In search arguments, nulls often mess up what would otherwise be crisp and fast query plans. Data values are sometimes unknown and the contrivances sometimes used to avoid the use of nulls in these cases are often more complicated than the use of nulls would be.
The bottom line is "avoid nulls unless you can produce a quantifiable advantage to having them".
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|