If data no change, order of result is fixed?

If you don't specify an ORDER BY then you are telling neo4j you don't care what order the results come back in.

More on this here

In your case, my first thought would be to try specifying what you see is the current default ORDER BY and check if performance is acceptable (it might be fast)

The thinking here is to specify an ORDER BY to assure we know how it is ordered, then if the default order changes in the future the query may slow down, but at least we've guaranteed that it will not return results in an unexpected order.

1 Like