Re: CASE Statements vs. Multiple Updates

From: Zach Wells (zwells_at_remove_ain1.com)
Date: 11/03/04 

Date: Wed, 03 Nov 2004 17:23:09 -0600

Rex Gibson wrote:
> Have a theory question:
>
> Which is FASTER a single select statment with 8 WHEN clauses or 8
> update statements.
>
> I assume the case statement but I am not sure.
>
> Are there circumstances when one might be faster than the other?
>
>

Your question doesn't make a whole lot of sense. CASE is an expression
that returns a single value. Update updates a table and logs the changes
to a transaction log. CASE will obviously be faster.

Zach