Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 07 Oct 2009 @ 11:38:10 GMT


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


Subj:   Re: Undestanding Explain Phrases
 
From:   Victor Sokovin

  Explain plan of a query contains following phrase:  


          > "(compressed columns allowed)
          >       fanned out into 26 hash join partitions,"
  Can you please help me understand what is meaning of this.  


You can look up the phrases in the Transaction Processing manual.

The first phrase confirms that compressed columns can go into the spool file, which is just a good news.

"Hash join partitions" in this case have nothing to do with the partitions on the tables but are rather internal partitions on spool files created by Teradata to split the large hash table into 26 smaller chunks which can fit in the allocated memory. Optimizer takes these decision based on available resources and such DBC parameters as Hash Table Memory Allocation and Skew Allowance.

Number of hash partitions is interesting to monitor over the time. If you see significant increase, it could be a signal to tune the DBC parameters and / or add resources.


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: 15 Jun 2023