Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=1022392 Card=934
Bytes=49502)
1 0 SORT (GROUP BY) (Cost=1022392 Card=934 Bytes=49502)
2 1 NESTED LOOPS (Cost=814767 Card=182275095 Bytes=9660580035)
3 2 TABLE ACCESS (FULL) OF 'TUD_FEDIA' (Cost=3 Card=30
Bytes=480)
4 2 PARTITION RANGE (ITERATOR)
5 4 TABLE ACCESS (FULL) OF 'TUH_NVPAGINA' (Cost=27159
Card=5992606 Bytes=221726422)
I was wondering how to read this plan, the order of steps. From old
set autotrace trace exp it seems to me that step 5 is the first step?
5 4 TABLE ACCESS (FULL) OF 'TUH_NVPAGINA' (Cost=27159
Card=5992606 Bytes=221726422)
