Archives of the TeradataForum

Message Posted: Sat, 20 Apr 2002 @ 17:27:44 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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".

Pat Belle
Teradata Certified Master

	<Prev	Next>		<<First	<Prev	Next>	Last>>