1 Reply Latest reply on Mar 22, 2019 8:56 AM by Albert Godfrind-Oracle

    Performance impact of PGQL queries with Property Graph indexes

    mohanr.k
    mohanr.k Mar 14, 2019 7:20 PM

      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