The table is going to be with 6000 rows. HOMEMAIN and HOMESUPP tables has 60 millions rows each.

[CODE ]

OPERATION OPTIONS OBJECT_NAME ID PARENT_ID POSITION
-------------------------------------------------------
CREATE TABLE STATEMENT ~ ~ 0 ~ 460400
LOAD AS SELECT ~ ~ 1 0 1
SORT GROUP BY ~ 2 1 1
MERGE JOIN ~ ~ 3 2 1
SORT JOIN ~ 4 3 1
TABLE ACCESS FULL HOMESUPP 5 4 1
SORT JOIN ~ 6 3 2
TABLE ACCESS FULL HOMEMAIN 7 6 1

[ END CODE]