Company
Date Published
Author
Petra Selmer
Word count
2253
Language
English
Hacker News points
None

Summary

The article provides an overview of how Cypher, a query language used in Neo4j graph databases, executes queries. It explains how the cost-based planner assigns costs to execution plans and selects the cheapest one, and how users can interact with query plans to make changes for better performance. The article also covers various optimization techniques such as using node labels, indexes, and constraints, splitting `MATCH` clauses, using size with relationships, forcing indexes, and avoiding Cartesian products. Additionally, it highlights the importance of keeping queries short and separating read and write queries. By applying these tips, users can improve the performance of their Cypher queries.