pritish-moharir commented on issue #2137:
URL: https://github.com/apache/age/issues/2137#issuecomment-2513837886
Hey @MuhammadTahaNaveed thank you for the quick response, we were able to
successfully create and use index scan for one of the label properties for ex
"NodeType1".name in this case.
A few questions we still have are :
1. The other labels like "NodeType2", "NodeType3" are still running
sequential scans, so we were wondering if there is a way to index on the joins
that are happening?
2. One of the queries we are using is like below:
```
SELECT * FROM cypher('graph_name', $$
MATCH (n1:NodeType1)
WHERE n1.attribute1 = '<value1>'
AND n1.attribute2 IN ['<value2>']
WITH n1
OPTIONAL MATCH (n1)-[:RelType1_NodeType1*1..1]-(n2:NodeType2)
WITH n1, n2
OPTIONAL MATCH (n1)-[:RelType2_NodeType1*1..1]-(n3:NodeType3)
WITH n1, n2, n3
OPTIONAL MATCH (n1)-[:RelType3_NodeType1*1..1]-(n4:NodeType4)
WITH n1, n2, n3, n4
OPTIONAL MATCH (n2)-[:RelType4_NodeType2*1..1]-(n5:NodeType5)
WITH n1, n2, n3, n4, n5
OPTIONAL MATCH (n3)-[:RelType5_NodeType3*1..1]-(n6:NodeType6)
WITH n1, n2, n3, n4, n5, n6
OPTIONAL MATCH (n5)-[:RelType6_NodeType5*1..1]-(n7:NodeType7)
WITH n1, n2, n3, n4, n5, n6, n7
WHERE n7.attribute3 = '<value3>'
AND n6.attribute4 = '<value4>'
AND n4.attribute5 = '<value5>'
WITH DISTINCT(n1) AS n1, n1.attributeKey AS n1_key
ORDER BY n1.attributeKey SKIP 0 LIMIT 10
OPTIONAL MATCH (n1)-[:RelType7_NodeType1*1..1]-(n8:NodeType8)
WITH DISTINCT n8 AS n8, n1, n1.attributeKey AS n1_key, n8.attributeKey AS
n8_key
ORDER BY n1.attributeKey, n8.attributeKey SKIP 0 LIMIT 10
OPTIONAL MATCH (n1)-[:RelType8_NodeType1*1..1]-(n9:NodeType9)
WITH DISTINCT n9 AS n9, n1, n8, n1.attributeKey AS n1_key, n8.attributeKey
AS n8_key, n9.attributeKey AS n9_key
ORDER BY n1.attributeKey, n8.attributeKey, n9.attributeKey SKIP 0 LIMIT 10
OPTIONAL MATCH
(n1)-[:RelType9_NodeType1*1..1]-(n10:NodeType10)-[:RelType10_NodeType10*1..1]-(n11:NodeType11)
WITH DISTINCT n11 AS n11, n1, n8, n9, n1.attributeKey AS n1_key,
n8.attributeKey AS n8_key, n9.attributeKey AS n9_key, n11.attributeKey AS
n11_key
ORDER BY n1.attributeKey, n8.attributeKey, n9.attributeKey, n11.attributeKey
SKIP 0 LIMIT 10
RETURN DISTINCT n1 AS NodeType1, n8 AS NodeType8, n9 AS NodeType9, n11 AS
NodeType11
$$) AS (n1 agtype, n8 agtype, n9 agtype, n11 agtype);
```
Its a bit complex but we were able to run the index scan for NodeType1
attribute1 and attribute2, but even after creating index on the other NodeType
attributes which are also queried, they are running sequential scan. Is there
something we are missing, do you have any suggestions as to what fields can be
indexed here? I apologise if this is a very straightforward question but any
inputs will be really helpful!
Please let me know if you need any additional information. Thanks!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
