Archives of the TeradataForum

Message Posted: Mon, 10 Dec 2007 @ 14:07:02 GMT

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

<-- Anonymously Posted: Mon, 10 Dec 2007 08:03 -->

Without ORDER BY, TOP n is effectively "first n". Both requests are all-AMPs but as long as there is no SyncScan TOP will probably default to reading the same "first" block on each AMP so it's possible you'd sometimes get the same result.

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