Archives of the TeradataForum

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

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

<-- 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>>