@chanakya@social.screamingatmyscreen.com
Post #2445509
2023-09-22 15:00 UTC
@chrisg@fosstodon.org Look at Hive. It has query hints to tell the optimizer how to transport data closer to where it is being processed. This is ala Oracle hints.
Replies (1)
-
@chanakya@social.screamingatmyscreen.com 2023-09-22 15:08
@chrisg@fosstodon.org You want to look at something that traverses an object model which does not have complicated joins, look no further than SOQL. IMO, this does a good job of balancing SQL familiarity, and object traversal necessity