Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 26 Mar 2004 @ 17:51:55 GMT


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


Subj:   Re: Aggregate Join Index & Fallback
 
From:   Victor Sokovin

Donald,

I'd say that in this scenario the query would fail. I think so because JI are not a part of the "front office" logical model; they are invisible "back office" clerks. If the table becomes unavailable due to an AMP failure or anything else, the database will have to fail the query due to the lack of integrity in the "front office".

All other factors you mentioned are valid but the first trouble will be the lack of database integrity beyond which TD won't go. This is just my guess. I did not have a chance to test this.


Victor



     
  <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: 23 Jun 2019