Hamza-Mushtaque commented on issue #920: URL: https://github.com/apache/age/issues/920#issuecomment-1546988441
Yes, It is possible to create an index on properties of nodes/edges in Apache AGE. Try using the following Cypher query: ``` CREATE INDEX ON :Person(roll); ``` This will create an index on the "roll" property of the "Person" nodes. And for using the created index for faster query `USING INDEX` clause in your Cypher query can be utilized. For example, to find all the "Person" nodes with "roll" property value of 25 using the index, try using following query. ``` MATCH (p:Person) WHERE p.roll = 25 USING INDEX p:Person(roll) RETURN p; ``` In this query, the `USING INDEX p:Person(roll)` clause tells Apache AGE to use the index on the "roll" property of the "Person" nodes for faster lookup. I hope this helps you. -- 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]
