Archives of the TeradataForum

Message Posted: Thu, 20 Aug 2015 @ 20:31:35 GMT


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

Subj:		Re: Case logic optimization

From:		Bakthavachalam, Roopalini

Thanks for the suggestion Tom. It did reduce the response time by few minutes. All along I was thinking it's the CASE that is causing the issue. Actually it's not the CASE, it's the DISTINCT that is killing the query.

My apologies for not stating the issue correctly before. Have been working on it for too long.

Is there any alternative of DISTINCT that can help this query? I have over 35 columns. I also tried to insert to a VOLATILE SET table, but it didn't help much.

Thanks

Roopalini