1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
| call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.04 0.06 0 0 0 0
Execute 2 0.02 0.02 0 0 0 0
Fetch 20 2.46 48.09 6354 17626 174 187
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 24 2.52 48.17 6354 17626 174 187
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 41 (ETUD)
Rows Row Source Operation
------- ---------------------------------------------------
94 SORT UNIQUE
97 HASH JOIN
343 INDEX FAST FULL SCAN (object id 79939)
97 HASH JOIN
97 FILTER
98 HASH JOIN OUTER
95 TABLE ACCESS FULL IM_INTASAI
151595 INDEX FAST FULL SCAN (object id 42234)
30296 TABLE ACCESS FULL ARTDGENE
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT GOAL: CHOOSE
94 SORT (UNIQUE)
97 HASH JOIN
343 INDEX GOAL: ANALYZED (FAST FULL SCAN) OF 'PARSOCPV_2'
(NON-UNIQUE)
97 HASH JOIN
97 FILTER
98 HASH JOIN (OUTER)
95 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'IM_INTASAI'
151595 INDEX GOAL: ANALYZED (FAST FULL SCAN) OF
'IM_INTCLIV_2' (NON-UNIQUE)
30296 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'ARTDGENE' |