Archives of the TeradataForum

Message Posted: Wed, 18 Jan 2006 @ 13:41:01 GMT

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

It's not that Teradata uses RowHash "rather than" the column values. It's "in addition to".

Using RowHash for distribution assures that rows that might have matching values are co-located.

And if rows are in RowHash sequence then a RowHash comparison potentially allows Teradata to "skip over" groups of rows that couldn't possibly match.

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