*************************[Explain Plan Time: 2020/05/13 15:07:38]*************************
Execution Plan
-----------------------------------------------------------
0 SELECT STATEMENT Optimizer=ALL_ROWS (Cost=105 Card=20 Bytes=2K)
1 0 SORT (AGGREGATE) (Card=1 Bytes=41)
2 1 NESTED LOOPS (Cost=7 Card=1 Bytes=41)
3 2 NESTED LOOPS (Cost=7 Card=1 Bytes=41)
4 3 TABLE ACCESS (BY INDEX ROWID BATCHED) OF 'LFMORD.STB_ORDER_PROD' (TABLE) (Cost=5 Card=1 Bytes=30)
5 4 INDEX (RANGE SCAN) OF 'LFMORD.IDX_ORDER_PROD_TUN' (INDEX) (Cost=4 Card=1)
6 5 TABLE ACCESS (BY INDEX ROWID) OF 'LFMDIS.STB_SOCIAL' (TABLE) (Cost=2 Card=1 Bytes=12)
7 6 INDEX (UNIQUE SCAN) OF 'LFMDIS.PK_STB_SOCIAL' (INDEX (UNIQUE)) (Cost=1 Card=1)
8 5 TABLE ACCESS (BY INDEX ROWID) OF 'LFMDIS.STB_SOCIAL' (TABLE) (Cost=2 Card=1 Bytes=12)
9 8 INDEX (UNIQUE SCAN) OF 'LFMDIS.PK_STB_SOCIAL' (INDEX (UNIQUE)) (Cost=1 Card=1)
10 3 INDEX (UNIQUE SCAN) OF 'LFMORD.PK_STB_ORDER' (INDEX (UNIQUE)) (Cost=1 Card=1)
11 2 TABLE ACCESS (BY GLOBAL INDEX ROWID) OF 'LFMORD.STB_ORDER' (TABLE) (Cost=2 Card=1 Bytes=11)
12 0 NESTED LOOPS (Cost=34 Card=20 Bytes=2K)
13 12 TABLE ACCESS (BY INDEX ROWID BATCHED) OF 'LFMDIS.STB_SOCIAL_PRODUCT' (TABLE) (Cost=13 Card=20 Bytes=1K)
14 13 INDEX (RANGE SCAN) OF 'LFMDIS.PK_STB_SOCIAL_PRODUCT' (INDEX (UNIQUE)) (Cost=2 Card=20)
15 12 PARTITION RANGE (ITERATOR) (Cost=2 Card=1 Bytes=15)
16 15 INDEX (RANGE SCAN) OF 'LFMCOM.PIDX_PRODUCT_TUN' (INDEX) (Cost=2 Card=1 Bytes=15)
-----------------------------------------------------------