5.1.2 Default Indexes on Vertex (VT$) and Edge (GE$) Tables
For query performance, several indexes on property graph tables are created by default. The index names follow the same convention as the table names, including using the graph name as the prefix. For example, for the property graph myGraph
, the following local (partitioned) indexes are created:
-
A unique index
myGraphXQV$
on myGraphVT$(VID, K)
-
A unique index
myGraphXQE$
onmyGraphGE$(EID, K)
-
An index
myGraphXSE$
onmyGraphGE$(SVID, DVID, EID, VN)
-
An index
myGraphXDE$
onmyGraphGE$(DVID, SVID, EID, VN)
Parent topic: Property Graph Schema Objects for Oracle Database