Archives of the TeradataForum

Message Posted: Wed, 14 Sep 2005 @ 13:06:26 GMT

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

Hi,

What makes you think there's a difference ?

I don't believe there's any difference in function or performance.

Assuming that Teradata knows that the DELETE statement is the last request in the transaction then it will use fast-path delete (i.e. only a single TJ row) for both queries.

Cheers,

Dave

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