Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 14 Mar 2008 @ 12:39:16 GMT


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


Subj:   Re: Join with column faster than join with primary index column?
 
From:   Chandana Oak

The table "PM_EDW_MSTR_D.d_ORGANIZATION" is a part of some cluster with the common column as PM_EDW_MSTR_D.d_ORGANIZATION.ORG_ID, whereas the table containing PARTY_ID as the primary index column will not be a part of the same cluster.

So, it could take a longer time to retrieve values for PM_EDW_MSTR_D.d_ORGANIZATION.ORG_ID.

Is this understanding correct?


Thanks,

Chandana Oak



     
  <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