Menu
I have a graph with many different elements but every element has a property "ID". Now i would like to
CREATE INDEX ON :anyType(ID)
How can i trigger the index creation for any type?
721
What makes creating a full-text schema index different from creating a property index? Full-text schema indexes can use relationship properties. Full-text schema indexes can check for uniqueness. Full-text schema indexes can use multiple types of nodes for the index.
Neo4j SQL supports Indexes on node or relationship properties to improve the performance of the application. We can create indexes on properties for all nodes, which have the same label name. We can use these indexed columns on MATCH or WHERE or IN operator to improve the execution of CQL command.
Indexes are commonly used for MATCH and OPTIONAL MATCH clauses that combine a label predicate with a property predicate.
To create a relationship between two nodes, we first get the two nodes. Once the nodes are loaded, we simply create a relationship between them. The created relationship is returned by the query.
CREATE INDEX ON takes a label, and cannot be called without the label (nor can it be called with multiple labels). So you'd have to execute this for each label type.
That is, you can't run:
CREATE INDEX(ID)
or
CREATE INDEX ON:*(ID)
You need to run:
CREATE INDEX ON:label(ID)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
