15.102 SEM_APIS.GET_PLAN_COST

Format

SEM_APIS.GET_PLAN_COST(
    query  IN CLOB
    ) RETURN NUMBER;

Description

Gets the cost of the execution plan for the query.

Parameters

query

The input query string.

Usage Notes

Examples

The following example gets the execution plan cost of the query.

SQL> SELECT sem_apis.get_plan_cost(q'[SELECT x, y
  2  FROM TABLE(sem_match(
  3   '{?x <email> ?y}',
  4   sem_models('m1'), null, null, null, null
  5  ,' ',null,null,'RDFUSER','MYNET')) order by 1,2]') pcost FROM DUAL;
               PCOST
--------------------
                   3
1 row selected.