Archives of the TeradataForum
Message Posted: Thu, 19 Jun 2008 @ 10:23:41 GMT
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).
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|