Archives of the TeradataForum

Message Posted: Thu, 20 Oct 2005 @ 10:54:17 GMT

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

I suspect if you run the derived table in its own right, the one with the group by will return considerably less rows. Therefore when the derived table is joined to table1 following the group by less spool is required as it is in fact a much smaller table than in the other example.

Regards

Keith.

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