Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
CASE vs IF |
Tue, Jul 13 2010 8:49 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | In a "simple" sql statement, in general terms, is it better (ie does it run faster) to use CASE rather than IF? I'm rapidly coming to the conclusion that CASE is more readable than nested IFs.
Roy Lambert |
Tue, Jul 13 2010 6:40 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< In a "simple" sql statement, in general terms, is it better (ie does it run faster) to use CASE rather than IF? I'm rapidly coming to the conclusion that CASE is more readable than nested IFs. >> It really doesn't matter in terms of performance - both are compiled into similar structures for execution. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Jul 14 2010 2:47 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
Thanks, and in that case I'll use CASE Roy Lambert |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |