Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 09 Jul 2005 @ 08:28:00 GMT


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


Subj:   Referential Integrity
 
From:   Anomy Anom

<-- Anonymously Posted: Saturday, July 09, 2005 04:03 -->

A couple of questions on RI.

How do I identify both tables bound by RI constraints?

Also, can anyone share any findings when using the 'soft-RI' feature? When does the optimiser decide not to join? Is it when PI selection is used? I'm seeing explains where a join is taking place even when columns from only one table are referenced.



     
  <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