Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 12 Jun 2004 @ 22:30:36 GMT


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


Subj:   Re: Performance Improvement on this Query without Collecting Statistics
 
From:   Victor Sokovin

  Do you run that query on a 20-AMP system? This results in 851 rows in Date table according to statistics, but in your first post you claimed "882 rows in DATE table". So you added one more month without updating statistics ;-)  


  This is no problem in this query, but might lead to incorrect spool sizes if you access using a "where date_col between ... and ...". As the table is small you should always have uptodate stats on it.  



There might be something else going on that the OP did not have a chance to describe for us. Alias "i" and AI_OLAP.FA_BCWK_IMP were not in the original query so perhaps some interesting views can be involved here as well?


Victor



     
  <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