When to use IF-THEN/ELSE vs. SELECT-WHEN If you have mutually exclusive conditions, either will work. Large numbers of conditions run faster with SELECT-WHEN.