Push the limit down to optimize match statement performance

[czpmango]

Many user scenarios need to optimize the performance of statements containing the limit clause, and the cost of pattern extension is often the key point. The optimizer can do some limit push down to improve these performance issues.

For example:

MATCH (v)-[e]->(n) WITH v, n LIMIT 8 RETURN v.prop

Current plan: ...->Traverse->AppendVertices->Limit->Project->...
Optimized plan: ...->Traverse(limit=8)->Limit->AppendVertices->Project->...

[zy857189690]

me too

[zy857189690]

+1

[tarzanwill]

+1