Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 25 Jun 2012 @ 10:32:16 GMT


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


Subj:   Re: How does Teradata work when merge join on MVC
 
From:   Vuyyuru_Ramaiah

Anomy.Anom wrote:

  how Teradata works when merge join (sort then join, right?) on MVC without decompression or merge join will not happen on MVC (?).  


Yes, It sort then join ( tables data should be present on same amp). It works for compressed columns (MVC) as well. When the values are comparing with one table to another table that time if it finds the compressed values (MVC) I think it decompress the values and perform the comparison with other table values during joining.



     
  <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