Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 03 Oct 2002 @ 23:08:06 GMT


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


Subj:   Re: Joins using varchar and char columns
 
From:   David Wellman

Bruce,

I can't see why it should, maybe you've hit a bug.

For example, a CHAR(10), a VARCHAR(30) and a CHAR(3) column each containing the same data value will generate the same hash value due to the way the hashing algorithm works. Certainly in the past I've run inner joins between different length CHAR columns (don't actually remember doing CHAR/VARCHAR columns) and the optimiser has recognised that rows to be joined are on the same AMP.

One thought. Are the character sets of the two columns the same? (i.e. both LATIN or both UNICODE). If not then that will almost certainly make a difference.


Cheers,

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)



     
  <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