Archives of the TeradataForum

Message Posted: Wed, 22 Mar 2006 @ 13:19:53 GMT

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

<-- Anonymously Posted: Wednesday, March 22, 2006 08:07 -->

My understanding is that TOP will basically go to 1 amp and say "give me your data". This is so long as you only say SELECT TOP n <columnlist> from Table;

As soon as you add smarts to the query (where clause, order by, etc...) the query must now execute on all amps and then bring the data together before returning just the n number of rows that you requested.

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