Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 19 Apr 2002 @ 15:27:12 GMT

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

Subj:   Re: Nulls in a composite Primary Key deployed as a Primary Index
From:   Cornelius Meade

Agreed...But while I don't generally condone this type of thing, I know that understanding the intricacies of properly dealing with possible NULL values often is a big problem in of itself for a population of users such that using dummy/special values becomes an alternative.

As for the broader implications of including nullable values in a composite primary index that seems to go against the definition of what a good primary index should be in Teradata. While it may make logical sense from a modeling perspective, I would caution against physically implementing it that way in Teradata if you can possibly find a better composite key/index that does not contain nullable columns, and that would be a better match for the ways Teradata uses primary index data....

  <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