Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 19 Feb 2008 @ 10:20:00 GMT


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


Subj:   Query randomly running for long time
 
From:   OmerAl

Hello All,

We are facing this issue for the third time now in the past 2 weeks. There are two tables (A key table and a transactions table) that are joined in a query during our daily load process, and sometimes (randomly) the query keeps running for 3-4 hours. When we drop the "key" table and recreate it and it starts working. At this point also, if we run the same query when nothing is being loaded the query keeps running without any results. If this was a daily thing we could have understood but it happens one day and then will not happen for a week. One of the tables gets Fast Loaded and all the other jobs that use the key table run fine except this one. Any ideas?

Thanks.


Regards,

Omar Alvi



     
  <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: 27 Dec 2016