Neo4j Labels and Schema Indexes

create

match p:Person, l:Location
where p.first_name! = {first_name} and l.location = {location}
create p-[:LIVES_IN]->l

curl.bash

curl http://localhost:7474/db/data/cypher?profile=true -X POST -H "Accept: application/json" -H "Content-type: application/json" -d '{"query" : "match p:Person where p.first_name! = \"George\" return p.first_name, p.last_name"}'

index1

create index on :Person(first_name)

index2

create index on :Person(last_name)

init

create (n:Person {first_name : "Peppa", last_name : "Pig"})
create (n:Person {first_name : "George", last_name : "Pig"})
create (n:Person {first_name : "Mummy", last_name : "Pig"})
create (n:Person {first_name : "Daddy", last_name : "Pig"})
create (n:Location {location : "The Pigs house"})
create (n:Person {name : "Bob the bat"})

match1

match p:Person
where p.first_name = "George"
return p.first_name, p.last_name

match2

match p:Person
where p.first_name! = "George"
return p.first_name, p.last_name

match3

match p:Person
where p.last_name = "Pig" and p.first_name = "Peppa" 
return p.first_name

match4

match p:Person
using index p:Person(first_name)
where p.last_name = "Pig" and p.first_name = "Peppa" 
return p.first_name