![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
![]() |
Tue, Jul 13 2010 8:49 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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. ![]() | 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 ![]() | Tim
Thanks, and in that case I'll use CASE ![]() Roy Lambert |
This web page was last updated on Monday, July 15, 2024 at 07:03 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |