Archives of the TeradataForum

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

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

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>>