Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: UPDATE Statement from another table
From:   Thomas F. Stanek


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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020