Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 05 Aug 2010 @ 13:17:00 GMT


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


Subj:   Re: Field update running slowly
 
From:   GRAHAM, Paul

The problem was due to the first column (which was the primary index) in the table being a member lapsed flag (containing 'y' or 'n'). Changing the primary index to a more distinct field (member number) has resolved this issue.

Thanks Dave for your help and code, which will be useful for future issue checking.

Thanks to all for your input.


Regards

Paul



     
  <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