Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Performance impact of PGQL queries with Property Graph indexes

mohanr.kMar 14 2019 — edited Aug 20 2020

I have below doubts on property graph indexes.

  1. Can we improve PGQL queries performance by creating Property Graph indexes. If so what indexing mechanism(Oracle Text, Solr, Lucene) provides this
  2. I tried creating Oracle Text Indexes on property keys. But looks like default indexes I don't see any indexes created in Database table
  3. When I try to retrieve index key properties I get all vertex and edge properties as keys. Does this mean by default all properties are used as index keys?

Any other suggestions on improving the query performance?

Below given are my environment details

Database: Oracle 18c

PGX: 3.1.0

Platform: Windows

Comments

Post Details

Added on Mar 14 2019
1 comment
241 views