Archives of the TeradataForum
Message Posted: Fri, 16 Apr 2004 @ 13:19:43 GMT
The CASE statement is going to be executed where you write it.
If you put it in the SELECT, it will test the data after it gets past the WHERE clause. Therefore, it is using SPOOL just the same as any other function.
If you write it in the WHERE clause, it tests the data along with the WHERE clause.
I hope this helps clear up some of your confusion.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|