How can I use range index in neo4j to support order by limit 1 and max functions? Is there any good solution for this problem?

Neo4j Graph Platform Cypher
1
  1. neo4j vesion 5.4
  2. I have created index
    image
    image1464×221 12.2 KB

max or order by not used index

image
image1138×648 36.1 KB

2

The query has no predicate (where clause) that specifically calls out time. Can you add the clause:

WHERE r.time IS NOT NULL

to the query?

4

Thank you It solved my problem