Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 23 Jan 2004 @ 15:18:53 GMT


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


Subj:   Re: Misunderstanding of join index
 
From:   Schroter, Andrew

JOIN indexes enable you to get query performance benefits closer to that of denormalizing data without bearing the costs of update anomalies and performing a denormalization of the data model. In addition, as JOIN INDEXES are updated as the underlying data is updated, the immediate availability of queries based on new "denormalized" views of data is dramatically improved compared to traditional denormalized schemes.


Andrew Schroter



     
  <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