Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 09 Feb 2004 @ 11:30:02 GMT


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


Subj:   Stored Procedure Performance and Transposing Data
 
From:   Passi, Hemanth

Hi,

I need a solution to the following problem.

col1 | col2

1       abc
1       def
1       sdf
1       fgh
2       ggh
2       ddd
-------
-------

the o/p desired is :

col1 | col2
1       abcdefsdffgh
2       gghddd
---
---

At the moment I'm running a pretty straight forward procedure that does the works for me. However, performance is a serious concern. I have 30-40 million unique values for col1 and 1-200 values (this number is a variable for each col1 value) in col2.

The client is MVS where I need to FEXP the results.

Any suggestions on alternate ways of implementation / improving the performance.


Thx! Cheers!!!



     
  <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