"Likely the problem with something like this is that there's a full-table scan on the Fruits table" What do you think the DBMS should do for a table with two t

"Likely the problem with something like this is that there's a full-table scan on the Fruits table" What do you think the DBMS should do for a table with two tuples? Regardless, it should be easier for the DBMS to use alternate plans if simple expressions aren't hidden behind a bunch of useless CASE statements.