Archives of the TeradataForum

Message Posted: Fri, 16 Apr 2004 @ 08:21:25 GMT

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

CASE is a Function and happens in line.

You wouldn't see it in an explain because it doesn't affect the execution plan in terms of spool.

It's impact is more likely to be see in terms of CPU activity.

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