Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=13402 Card=1 Bytes=1
08)

1 0 SORT (AGGREGATE)
2 1 SORT* (AGGREGATE)
:Q173820

04
3 2 HASH JOIN* (Cost=13402 Card=28 Bytes=3024)
:Q173820

04
4 3 HASH JOIN* (Cost=12290 Card=132 Bytes=12408)
:Q173820

03
5 4 HASH JOIN* (Cost=5347 Card=146 Bytes=11680)
:Q173820

02
6 5 HASH JOIN* (Cost=939 Card=5087 Bytes=264524)
:Q173820

01
7 6 TABLE ACCESS* (FULL) OF 'ded_1896_173' (Cost=4
:Q173820
78 Card=5124 Bytes=199836)
00

8 6 TABLE ACCESS* (FULL) OF 'PSC_ELIG' (Cost=461 C
:Q173820
ard=49221460 Bytes=639878980)
01

9 5 PARTITION RANGE* (ALL)
:Q173820
02
10 9 TABLE ACCESS* (FULL) OF 'ACCOUNT' (Cost=4408 C
:Q173820
ard=433568 Bytes=12139904)
02

11 4 PARTITION RANGE* (ALL)
:Q173820

03
12 11 TABLE ACCESS* (FULL) OF 'SUB_ACCOUNT' (Cost=6943
:Q173820
Card=66260500 Bytes=927647000)
03

13 3 PARTITION RANGE* (ALL)
:Q173820

04
14 13 TABLE ACCESS* (FULL) OF 'PARENTAL_CONTROL' (Cost=1
:Q173820
112 Card=15800800 Bytes=221211200)
04

2 PARALLEL_TO_SERIAL SELECT /*+ PIV_SSF */
SYS_OP_MSR(COUNT(*)) FROM (SELECT /*+ ORDERED NO_EXPAND US

3 PARALLEL_COMBINED_WITH_PARENT
4 PARALLEL_TO_PARALLEL SELECT /*+ ORDERED NO_EXPAND
USE_HASH(A2) */
A2.C0 C0,A2.C1 C1 FROM :Q17382002 A

5 PARALLEL_TO_PARALLEL SELECT /*+ ORDERED NO_EXPAND
USE_HASH(A2) */
A1.C0 C0,A1.C1 C1 FROM :Q17382001 A

6 PARALLEL_TO_PARALLEL SELECT /*+ ORDERED NO_EXPAND
USE_HASH(A2) */
A2.C0 C0,A2.C1 C1 FROM :Q17382000 A

7 PARALLEL_TO_PARALLEL SELECT /*+ NO_EXPAND ROWID(A1) */
A1."ACCOUN
T_NO" C0,A1."SUB_ACCOUNT_NO" C1 FROM

8 PARALLEL_COMBINED_WITH_PARENT
9 PARALLEL_COMBINED_WITH_PARENT
10 PARALLEL_COMBINED_WITH_PARENT
11 PARALLEL_COMBINED_WITH_PARENT
12 PARALLEL_COMBINED_WITH_PARENT
13 PARALLEL_COMBINED_WITH_PARENT
14 PARALLEL_COMBINED_WITH_PARENT

Oracle LazyDBA home page