Re: Why no row source plans in tkprof output? -- More info please read...

Egorts,

Thanks for the reply but I do not think so since our instance has that set to TYPICAL and here is the test I did below:

select *
from
 fnd_user where user_name = 'BPHAM'

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        2      0.00       0.00          0          3          0           1
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        4      0.00       0.00          0          3          0           1

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS

Rows     Row Source Operation
-------  ---------------------------------------------------
      1  TABLE ACCESS BY INDEX ROWID FND_USER
      1   INDEX UNIQUE SCAN FND_USER_U2 (object id 33856)

********************************************************************************

alter session set sql_trace = false