what i wanted the reader to focus on is here,
the extra table and index scan:
=====================
PARSING IN CURSOR #3 len=47 dep=2 uid=0 oct=3 lid=0 tim=11151271963
hv=1023521005 ad='1a6876ec'
select metadata from kopm$ where name='DB_FDO'
STAT #3 id=1 cnt=1 pid=0 pos=1 obj=353 op='TABLE ACCESS BY INDEX ROWID KOPM$
(cr=2 pr=0 pw=0 time=75 us)'
STAT #3 id=2 cnt=1 pid=1 pos=1 obj=354 op='INDEX UNIQUE SCAN I_KOPM1 (cr=1 pr=0
pw=0 time=42 us)'
=====================
the fact that transformations and casts need to be done in order to generate a table expression from pl/sql to sql. KOPM$ is not specified anywhere in the examples. They are used "under the covers" to produce our "pipelined" results.
|