BennySobol opened a new issue, #2141: URL: https://github.com/apache/age/issues/2141
I want to optimize a MERGE query to utilize an index on a vertex/edge property. I want to query the graph like this: MERGE (a:Entity {id: 'id-a'})-(r:Relation {id: 'relation-id'})->(b:Entity {id: 'id-b'}) SET r = ... I want to ensure the following conditions are met: I need to enforce a unique constraint on the id property both on Entity and Relation I do not want to use a GIN index because it consumes more space, and I prefer a more efficient index for this scenario. I want to ensure the index is used when performing the above query for an exact lookup by id. Unfortunately, the documentation does not provide clear guidance on how to handle indexing in Apache AGE Could you please provide guidance on how to achieve this setup - how to create the index? -- 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: dev-unsubscr...@age.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org