Updating a node label from a property or creating an index

[bill_dickenson]

We have a property in our db that has gotten more important over time and we are searching on it a lot. We have been debating either making it a node label, or creating an index on the property. So if the structure were

a:ProgNode {KDM:p1, size:10,etc etc

Would we be better just creating an index on KDM or defining it like this

a:ProgNode:KDMVALUE {size:10, etc etc)

If the answer is define it as a label on Node, is there a simple cypher that can do it ? Thanks

[intouch_vivek]

Hi @bill.dickenson,

I would suggest to have a look into the requirement and indexes in Neo4j.

Neo4j Graph Database Platform

Labels and Schema Indexes in Neo4j - Neo4j Graph Database Platform

Neo4j recently introduced the concept of labels and their sidekick, schema indexes. Labels are a way of attaching one or more simple types to nodes (and relationships), while schema indexes allow to automatically index labelled nodes by one or more…...

OR
Several other documents available at Neo4j.

Inshort, Label Index to restrict the Search on given Label and is nothing to do with property value present in the Label. On the other hand when you create a Explicit property index then your search will look into the index to fulfill the search result.

[ameyasoft]

Creating a unique constraint on a node property worked for me in a production environment.

[bill_dickenson]

Thank you all. That was very helpful.