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?


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: 28 Jun 2020