Archives of the TeradataForum
Message Posted: Fri, 03 Oct 2002 @ 23:08:06 GMT
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.
Ward Analytics Ltd: Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|