Sign In/My Account | View Cart  

advertisement

AddThis Social Bookmark Button

Article:
  Using the New MODEL Clause in Oracle Database 10g
Subject:   10G - not useless.
Date:   2004-08-19 20:14:54
From:   amolinaro
Response to: 10G - not useless.

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.