Archives of the TeradataForum
Message Posted: Thu, 20 Aug 2015 @ 20:31:35 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|