I have a question about how Neo4j handles ORDER BY with a composite index.
Let's say I have some nodes with a composite index on their time created and their "rank".
I only want to query using their time created - stuff from the last day, for example - but I then want to order them by their rank.
If I only using the time index to filter out the nodes, would neo4j still use the composite index, thereby giving me a performance boost for the ORDER BY portion of the query, since the nodes should ideally already be in order from their rank index?
Or, would neo4j just use the time index, then use run a regular SORT using the rank?
Or, would it use the composite index, but still have to run a SORT regardless, as the composite index may not be ordered according to just rank?
Please let me know if you have any clarifying questions.
Thank you!
Matt