Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023