Hi, I am new to neo4j and have some questions
I am evaluating the query performance under different join orders (query is written in Cypher)
According to Neo4j manual, I can input several hints such as index, scan, and join hints.
Index hints are used to specify the starting nodes for joins.
Join hints are used to specify the joining nodes for joins.
However, there seems to be no way to force certain join orders.
For example, say a query Q is given as follow:
v1 -- v2 -- v3
....... v4 -- v5
How can I evaluate the query performance for different join orders such as:
(1) (v1, v2, v3, v4, v5)
(2) (v1, v2, v4, v5, v3)
(3) (v2, v3, v4, v5, v1)
Currently, using the index and join hints, I can only make certain join orders (Not all of possible orders)
Is there any way to achieve it?
(In Oracle DB, it is achieved by using ORDERED)
Thanks for your attention,