Archives of the TeradataForum

Message Posted: Wed, 06 Feb 2002 @ 20:17:31 GMT

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

Matt,

You really need to look at the explain (as suggested by Cathy Thompson) to determine the performance problem. There is nothing "wrong" with updating the contents of one table from data in another table. I don't think your system size is the issue here. I would guess that the performance problem has to do with the join plan being created. Also, as a reference point, you might want to try running a SELECT with the same join criteria and see how quickly that runs.

If nothing shows up there, is it possible that the spool required to satisfy the request is so large that it is causing Mini-CylPacks? This will slow down not only your query, but everyone else on the system as well.

Hope this helps.

Thomas F. Stanek
TFS Consulting

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