Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> case short circuits?

case short circuits?

From: tq <tomm_quinn_at_yahoo.com>
Date: 20 Jun 2005 14:27:46 -0700
Message-ID: <1119302866.015792.23990@g43g2000cwa.googlegroups.com>

Question about this case statement below - is it actually evaluating the 3=3 or does it short ciruit? I'm trying to judge decode versus case in terms of potential performance differences.

case when 1=2 and 3=3 then 0 else 1 end

Thanks. Received on Mon Jun 20 2005 - 16:27:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US