Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 11 Feb 2010 @ 09:32:12 GMT


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


Subj:   Help required in optimization
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, February 11, 2010 04:14 -->

Hi Friends,

Please help me out in tuning the query of the below format...

     insert into table_x
     sel distinct a.loc_cd
     a.num as num1
     b.num as num2
     from table_x a,
     table_x b
     where a.loc_cd = a.loc_cd
     and a.num


The target table has PI (loc_cd,num1,num2) and the source table has the PI (loc_cd,num). The above query has problem of Skewness.

Thanks a lot in advance...



     
  <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