Archives of the TeradataForum
Message Posted: Fri, 19 Sep 2003 @ 13:16:22 GMT
I'm facing new problem in one of my SQL(INSERT/SELECT) target table is empty , SQL has couple of left outer and inner joins , it works fine every night , it INSERTs some thousand rows in few minutes. Suddenly from yesterday its running for long time , select count(*) for the same join works fine , but actually it has couple of CASE WHEN statements in SQL , does these CASE statements in SELECT degrades performance?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|