Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 07 Oct 2009 @ 08:35:52 GMT


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


Subj:   Undestanding Explain Phrases
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, October 07, 2009 01:37 -->

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.

The table is having UPI and no partition.

For confidential reason I can not post the entire query on forum but any help would be appreciated.

Some additional information: The table to which this table in being joined is have a partion on date column but the tables are not being joined on that columns but on UPI of this column.

Let me know if you need any additional information.


---thanks

Curious



     
  <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