Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Nulls in a composite Primary Key deployed as a Primary Index
From:   Patrick A. Belle

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020