Archives of the TeradataForum

Message Posted: Tue, 23 Jan 2001 @ 18:00:11 GMT

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

Remember, that on a join where the primary indices are identical (or for that matter, if an index is used, period) that Teradata indexes are hashed. The data values were hashed when the data was put into the database, so there IS NO PENALTY when doing the join. Size doesn't make a difference IF THE INDEX IS USED. I don't know if hashing takes longer on Varchars, but I don't think that's the question.

--------------------------------------------

I accept that comparing longer datatypes takes longer than shorter ones (linear increase?)?

Frank C. Martinez IV

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