1

Can I create index on more than one property for any given label? I am running query like:

MATCH (n:Node) WHERE n.id = xyz AND n.source = abc;

and I want to know whether I can create multiple property indexes and if not, is there a good way to query for nodes matching multiple properties?

KateLatte
  • 611
  • 1
  • 12

1 Answers1

1

Memgraph does not support composite indexes, but you can create multiple label-property indexes. For example, run

CREATE INDEX ON Node(id);
CREATE INDEX ON Node(source);

To check if they are properly created, run SHOW INDEX INFO;.

Use EXPLAIN/PROFILE query (inspecting and profiling queries) to see different options and test the performance, maybe one label-property index is good enough.

KateLatte
  • 611
  • 1
  • 12