Archives of the TeradataForum
Message Posted: Tue, 29 May 2012 @ 13:08:23 GMT
TOP displays the first 10 rows in Sorted order from the table. The optimizer is free to select the cheapest plan it can find and stop processing as soon as it has found enough rows to return.
SAMPLE displays any 10 rows randomly from the table. Performance wise is better to use TOP.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|