Archives of the TeradataForum

Message Posted: Thu, 03 Aug 2006 @ 14:48:34 GMT

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

If you have the 2 queries as a MSR in the single session approach then you might get shared processes (depending on the data overlap and query similarity) . So this might reduce spool consumption.

The sync scan capability across 2 queries would be in effect for either case.

Cheers

John

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