Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 31 Aug 2010 @ 18:55:10 GMT


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


Subj:   Re: ETL jobs hanging, Index needs to be changed
 
From:   Prasad Kavil Kambrath

If you change those columns to NUPI, your update statement will run faster. But I guess the locking issue will not be resolved. Could you please try to lock the row for update. Even though row level lock locks more than one row basesd on row has, it might help you


Thanks,

Prasad



     
  <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