Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 12 Jun 2004 @ 10:45:53 GMT

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

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

  The first thing you should do is get and analyze the explain. Anything you do before that is trial and error based on theory and speculation. It is much easier to solve a problem when you know, in detail, what the problem is.  

I don't think one would get a lot of insight out of analysis of explains only in cases like the one discussed here, i.e., conversion of daily figures into the weekly aggregates with the volumes as described by the OP. That's the process which is in place in many companies and the problems and their resolutions seem to be very similar. Usually it is either a purchase of more hardware (often preceded by months of analysis and ever deteriorating performance) or rewriting the query in a more economical way. The second approach often leads to immediate visible results. I think some of the suggestions made in the thread are based on the authors' experience with the second approach.



  <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