Archives of the TeradataForum

Message Posted: Tue, 21 Nov 2006 @ 22:07:32 GMT

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

<-- Anonymously Posted: Tuesday, November 21, 2006 16:05 -->

I suppose EXPLAINs before and after are too much to hope for...

First thing you need to figure out is where it's spending the extra time. For example, is it in FETCH/JOIN part of the INSERT/SELECT or the MERGE part? Don't rely on EXPLAIN for this; monitor it as it runs or use DBQL STEPINFO. Then if the problem isn't obvious, post more details and maybe someone can help.

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