Skip to Main Content
Graph Data Processing with Cypher
book

Graph Data Processing with Cypher

by Ravindranatha Anthapu
December 2022
Intermediate to advanced content levelIntermediate to advanced
332 pages
6h 35m
English
Packt Publishing
Content preview from Graph Data Processing with Cypher

9

Query Tuning

Till now, we have looked at various aspects of building Cypher queries. In this chapter, we will take a look at which options are available to profile and tune queries.

We have two options available to tune queries. The first one is the EXPLAIN clause, which takes the Cypher query and provides an estimated amount of work the database might do. It does not execute the query. The other one is the PROFILE clause. This will execute the query and gives the exact amount of work the database is doing. We will review both of these options in detail to understand how to leverage them to tune queries.

We will be taking a look at these aspects:

  • Working with EXPLAIN
  • Working with PROFILE
  • Reviewing plan operators
  • Using index hints

First, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Graph Algorithms for Data Science

Graph Algorithms for Data Science

Tomaz Bratanic
Graph Data Modeling in Python

Graph Data Modeling in Python

Gary Hutson, Matt Jackson

Publisher Resources

ISBN: 9781804611074Supplemental Content