Indexing and Query Performance
I am working on fine tuning a query so that it becomes faster. The query is like:
g.V().has('Index1','123').as('p').out('has_rel1').has('Index2,within('A','B').as('q').dedup().out('has_rel2').has('Index3','X').as('r').select('p','q','r').by('id')
How to ensure all the three index are used for searching. I created index for all the 3 search attribute named as Index1, Index2 and Index3. But while doing profile I can see only Index1 being used.
Any suggestion.
Fyi, Firstly I created all as Composite index, but since index2 isnt using equality, so later made it as mixed index, but still no changes.
g.V().has('Index1','123').as('p').out('has_rel1').has('Index2,within('A','B').as('q').dedup().out('has_rel2').has('Index3','X').as('r').select('p','q','r').by('id')
How to ensure all the three index are used for searching. I created index for all the 3 search attribute named as Index1, Index2 and Index3. But while doing profile I can see only Index1 being used.
Any suggestion.
Fyi, Firstly I created all as Composite index, but since index2 isnt using equality, so later made it as mixed index, but still no changes.
