Splice Machine interview question

Possible optimization in SQL execution plan generation.