Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019