Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 24 Sep 2001 @ 21:15:49 GMT


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


Subj:   Re: Updating one table with values from another
 
From:   Thomas F. Stanek

Karen,

The explain looks pretty reasonable to me. Do you have any idea if the query was doing real work, i.e. consuming CPU cycles and IO? Check DBC.AMPUSAGE. I'm wondering if your query is being blocked. Is it possible that you have a Utility lock on that table or database left over from an archive or restore? Check SHOWLOCKS. If the query is doing work, is the query skewed? I doubt it if you have a unique primary index on terr_id.

Hope this helps.


Regards,

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: 15 Jun 2023