Archives of the TeradataForum

Message Posted: Thu, 19 Jun 2008 @ 10:23:41 GMT

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

You didn't provide enough info regarding the performance.

Do the EXPLAINs differ? And if so, how?

Particularly if the EXPLAINs seem to match, consider running with DBQL STEPINFO logging. You may find the extra time is actually being spent in the SELECT part (USING) rather than INSERT (or UPDATE).

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