Archives of the TeradataForum

Message Posted: Wed, 22 Jun 2005 @ 20:53:47 GMT

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

All true. But preparation for a join is not the only reason to sort. Sometimes, we sort to eliminate duplicates. This is probably most often done to handle DISTINCT, but it also shows up when dealing with subqueries.

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