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.
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.
Parent topic: SEM_APIS Package Subprograms