Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 16 Dec 2015 @ 19:30:26 GMT


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


Subj:   Why there is a USI restriction on Join Indexes.
 
From:   Chennapragada, Somasankaram

Hi Forum

Why there is a USI restriction on Join Indexes.

-- I have read that USI cannot be created on Join Indexes. Any specific reason why USI cannot be created? Please explain me in detail.

-- I also read that changes to USI is Transient Journaled and NUSI is not transient Journaled. Is it changes in data values of USI/NUSI columns or changes in Columns(for ex: col1 was USI and now we have changed to col2).?

Any detailed explanation on both these questions will be highly appreciated.


Best Regards,

Shankar



     
  <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: 27 Dec 2016