Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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


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.


Thomas F. Stanek
TFS Consulting

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020