CODEWITHSUNDEEP
memgraphdb
KateLatte
KateLatte

Reputation: 728

Are composite indexes supported in Memgraph?

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?

Upvotes: 1

Views: 168

Answers (1)

KateLatte
KateLatte

Reputation: 728

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.

Upvotes: 1

Related Questions