Hi,
Need understanding on the usage of indexes in gremlin query for OrientDB.
As I understand, graph database can make use of Global indexing and Vertex
Centric indexing where Global indexing is used at the initial level to land
on the starting point of traversal and Vertex centric indexing(property or
edge indexing) is what is used post the initial narrowing of the result is
done in the filter criteria. I am not sure if Vertex Centric indexing has
been implemented in Orient DB.
For improving the gremlin query performance, I need to develop indices on
vertex properties depending upon how they are interpreted in the filters.
So want to understand if the indices are used in the filter criteria post
the initial search for vertices. If yes, how can we verify their usage.
This is a sample query that I am using
g.V().hasLabel('NetworkSite').where(outE('PlacePhysicalResourceAssoc').has('placeRole','TRSArea').inV().hasLabel('Chassis').out('EntityHasSpecifications').has('name','Alcatel
7750SR
CORE')).where(inE('GeoSiteRelationship').has('siteRelationType','RefersTo').outV().has('PointOfPresence','siteStatus',without(['Capped','BESPOKE']))).where(out('EntityHasRoles').has('name',within('Core','Metro','CMSAN','FMSAN','WMSAN'))).as('a')
.match(__.as('nw').out('PlacePhysicalResourceAssoc').hasLabel('Chassis').out('DeviceSupportedByEquipment').has('inventoryStatus',within('Installed','Planned')).where(out('EntityHasSpecifications').has('name',within('FSP150
- CP Version')).has('usage',within('EAD','Ethernet Edge Aggregator','Multi
Service Edge','Fringe
PE'))).where(__.in('EntityHasCharacteristics').has('charName','WorkerStandByIndicator').has('charValue','Worker')).fold().as('devices')).select('nw','devices')
Thanks
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
