3 Replies Latest reply: Sep 4, 2012 6:47 PM by alwu-Oracle RSS

    How to improve performance using SDO_RDF_MATCH

    366556
      Hello,

      I have a virtual model that I created from an entailment containing about 10 models. It has approx 7.5 million triples. And running a simple query as follows could take about 30-35 sec:

      select x, o, y, o1, z, o2, f
      from table(sdo_rdf_match(
      '{ ?x ?o ?y .
      ?y ?o1 ?z
      optional {?z ?o2 ?f}}',
      sdo_rdf_models('vm_m'),
      null,
      null,
      null,
      null));

      I have 11.2.0.3 database running on a Sun Solaris server.
      I've analyzed the entailmend and run refresh_sem_network_index_info.

      Is there a way to speed this query?

      Thanks,
      A.