Archives of the TeradataForum

Message Posted: Fri, 19 Sep 2003 @ 13:16:22 GMT

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

All,

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?

Thanks,

Rick

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