Archives of the TeradataForum

Message Posted: Tue, 01 Aug 2006 @ 14:27:27 GMT

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

Hi,

Consider the following two scenarios:

1) There is a single session of a user. The user executes two queries in a parallel fashion.

2) There are two sessions of the same user. Two queries are executed separately in the two sessions. These queries are submitted with, say, a very negligible time difference.

Which one of the two scenarios would return the results faster?

Also, which one will consume fewer resources?

Will there be any difference in the spool space consumed?

Regards,

Bhakti Bongale

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