Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 10 Apr 2006 @ 10:46:21 GMT


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


Subj:   Re: Identity Column & UPI
 
From:   Anomy Anom

<-- Anonymously Posted: Monday, April 10, 2006 01:35 -->

If an identity column is defined with CYCLE or with MINVALUE or MAXVALUE, does it still produce unique numbers, for a set of rows exceeding the limit? Assuming there are no limitations and it produces only unique values and defining it as UPI, does teradata internally, still checks for duplicate primekey? If yes, then there would be some performance impact.



     
  <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