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