Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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.



  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023