Archives of the TeradataForum
Message Posted: Wed, 22 Jun 2005 @ 20:53:47 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|