Archives of the TeradataForum

Message Posted: Wed, 22 Jun 2005 @ 20:10:48 GMT

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

<-- Anonymously Posted: Wednesday, June 22, 2005 16:05 -->

First of all, we need to understand that there are different kinds of joins. All joins doesn't require sorting. The decision to join 2 tables by a particular join kind is made in the optimizer based on the cost to perform the join. The basic join kinds are merge join, product join, nested join, hash join. Only merge join and nested join require sorting. Product and hash join doesn't require sorting. The sorting behaviour is same in all databases.

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