Skip to content
Related Articles

Related Articles

Neo4j Create Index
  • Last Updated : 28 Aug, 2019
GeeksforGeeks - Summer Carnival Banner

In neo4j you can create index for both property and nodes. Indexing is data structure that helps faster performance on retrieval operation on database. There is special features in neo4j indexing once you create indexing that index will manage itself and keep it up to date whenever changes made on the database. Similarly CREATE INDEX ON statement will provide the indexing.

Example: In the below example we create index on the Tag property of all nodes with the GeeksforGeeks label.

  • $ CREATE INDEX ON:GeeksforGeeks(Tag)
    

    Output:

    Note:
    When you create an index, neo4j will create the index in background. If your database is large it will take some time.

    View Index:
    Index and Constraint is the part of the database schema. To view the indexes you have to use :schema command, like below example.

  • :schema

    Output:

    Index hints:
    If the indexing is exist on your database then it will be helpful when you triger similar type of queries, it improves the performance. You can create an index hint by including USING INDEX … in your query.

  • $ MATCH (a:GeeksforGeeks {Tag: "A Computer Science Portal"}) 
    USING INDEX a:GeeksforGeeks(Tag) 
    RETURN a 

    Output:

    Note: You can also provide multiple hints. Simply add a new USING INDEX for each index you’d like to enforce.

    Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.

    My Personal Notes arrow_drop_up
  • Recommended Articles
    Page :