Archives of the TeradataForum

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

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

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