graph - How can I create in Cypher an index that involves 2 primary keys?

Question

I am creating a graph in Neo4j and I am starting by creating indexes. One index is linked to one csv file Product whose primary key is productID, another Client with clientID as PK and there's another file called ShoppingCart which contains ProductId and ClientId as PK.

Then how can I create an index for ShoppingCart? Or is it not needed?

CREATE INDEX ON :Product(productID);
CREATE INDEX ON :Client(clientID);
CREATE INDEX ON :ShoppingCart?????

Thanks!

question from:https://stackoverflow.com/questions/65864232/how-can-i-create-in-cypher-an-index-that-involves-2-primary-keys

Answer 1

With Neo4j 3.x, the syntax is:

CREATE INDEX ON :ShoppingCart(productID, clientID)

With Neo4j 4.x, the syntax is:

CREATE INDEX shopping_cart_index FOR (n:ShoppingCart) ON (n.productID, n.clientID)

Note: at the time of writing, only Neo4j 3.5.x is supported in the 3.x series.