Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 09 Jul 2004 @ 12:24:25 GMT


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


Subj:   Re: Performance of query which does weekly aggregates
 
From:   Hassinger, Bill

I don't think you will pick up 35 seconds, but as long as your using sys_calendar already use Week of Calendar instead of calculating the begin and end dates ( if the SUN - Sat format fits your definition).

We don't have V2R5, but if you do, you can look at partition index or some other index methods which would more likely make a higher performance improvement.



     
  <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