Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 20 Feb 2008 @ 09:37:27 GMT


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


Subj:   Re: Query randomly running for long time
 
From:   OmerAl

The key table is not fast loaded. It is the other table in staging that gets fast loaded and is joined with the key table. We run statistics on the key table but now we have started archiving keys because they are on transactions. So we have very less number of rows to join now so even not running statistics would actually not be a problem.

I did not get what you mean by 'timing issue'?


Regards,

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