Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 24 Feb 2009 @ 20:21:03 GMT


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


Subj:   Re: Too much time spent on aggregate function
 
From:   Dieter Noeth

Simard Rudel wrote:

  Like you see, english is not my native language, so may be I exposed the problem to simplistic ;-)  


It's my native language neither, but my french is not better :-)


          > >     ---------- Last group of service    ----------
          > >
          > >     LEFT JOIN ((SELECT A.NO,A.NO_ACTIV,A.NO_ASK,
          > >                        MAX(R.NO_REGR_MES) NO_LAST_GROUP_SERV
          > >                 FROM   ........

That's it, it looked like "........" is "DB_NAME.TREGR_MES", but "........" is a different table?


          > >                 GROUP BY 1,2,3) AS TNO_REGR
          > >
          > >                INNER JOIN DB_NAME.TREGR_MES ON
          > >                    .........
          > >                    AND TNO_REGR.NO_LAST_GROUP_SERV =
          > >                       TREGR_MES.NO_REGR_MES)
          > >
          > >     ON .....

Dieter



     
  <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