Archives of the TeradataForum
Message Posted: Wed, 06 Feb 2002 @ 20:17:31 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|