1. Graph Developer's Guide for Property Graph
  2. Getting Started with Oracle Property Graphs
  3. Using the Property Graph Schema
  4. Property Graph Schema Objects for Oracle Database
  5. Default Indexes on Vertex (VT$) and Edge (GE$) Tables

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$ on myGraphGE$(EID, K)

  • An index myGraphXSE$ on myGraphGE$(SVID, DVID, EID, VN)

  • An index myGraphXDE$ on myGraphGE$(DVID, SVID, EID, VN)

Parent topic: Property Graph Schema Objects for Oracle Database