3 ms·
I think the simpler takeaway is that OR consistently represents a branch in the query planning, where the planner now always has to do two things and merge back
by sudhirj 7y ago
I think the simpler takeaway is that OR consistently represents a branch in the query planning, where the planner now always has to do two things and merge back instead of one. It makes sense for the OR operations to always preserve this inefficiency instead of leaving the user guessing when it will or won’t.
- beart 7y agoI don't understand why that makes sense? Isn't the point of a declarative language to remove the need to consider these details?
- cyborgx7 7y agoI have long since resigned myself to the fact that "declarative language" in practice only means that you don't have to manually write the for-loops anymore. The concept of declarative languages seems like it has so much potential, but I haven't seen any that have even come close to it.