Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 06 Jul 2005 @ 19:01:39 GMT

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

Subj:   Re: Partitions and indexes
From:   Anantaraman, Kumaran (K.)

Anonym wrote :

  1. Why is it that a unique primary index cannot be defined if the partitioning column is not included as a part of the PI? I want to understand the "theory" behind this!!  

How about this?

TD has to check for duplicate UPIs when inserting rows. If partition does not include all UPI columns, then TD may have to search IN ALL partitions for existing rows with same UPI values that may conflict with new incoming row.

Kumaran Anantaraman

  <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: 15 Jun 2023