Archives of the TeradataForum

Message Posted: Fri, 21 Oct 2005 @ 09:04:21 GMT

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

Have you looked at the explains?

If you explain the second query, you will see that it performs an aggregation step. If there are lots of repeated rows in col3, col4, this step will eliminate them. Thus the "size" of the derived table b will be smaller in the second query. If so, this will translate into a smaller spool requirement.

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