These are my edits for join order hints. I'll open a new branch for my other commits. So @andyfengHKU can take over, do further edits and merge.
Note that I made 3 or 4 assumptions (e.g., the disconnectedness criteria, or left/right of JOIN affecting probe/build side), or that MULTI_JOIN with a single relationship being treated as JOINs (see the very last paragraph). I also opened these issues related to these edits (some of which may be obsolete if they're documentation-related issues and the documentation that I wrote resolves them):
These are my edits for join order hints. I'll open a new branch for my other commits. So @andyfengHKU can take over, do further edits and merge.
Note that I made 3 or 4 assumptions (e.g., the disconnectedness criteria, or left/right of JOIN affecting probe/build side), or that MULTI_JOIN with a single relationship being treated as JOINs (see the very last paragraph). I also opened these issues related to these edits (some of which may be obsolete if they're documentation-related issues and the documentation that I wrote resolves them):
https://github.com/kuzudb/kuzu/issues/4019 https://github.com/kuzudb/kuzu/issues/4020 https://github.com/kuzudb/kuzu/issues/4021 https://github.com/kuzudb/kuzu/issues/4022 https://github.com/kuzudb/kuzu/issues/4023 https://github.com/kuzudb/kuzu/issues/4024
Finally, your call but I suggest removing
_fromMULTI_JOIN. I find_hard to type.