Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 16 Apr 2004 @ 13:19:43 GMT


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


Subj:   Re: Resolving the CASE expression
 
From:   Michael Larkins

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.


Michael Larkins
Certified Teradata Master



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016