DELETE /*+ DYNAMIC_SAMPLING(3) */ FROM fcstdraft f
WHERE f.TYPE = 4
and exists ( select 1 from scpomgr.dfumap d, scpomgr.map m where m.map=d.map and
m.u_reconci_freq='DAILY' and m.u_reconci_calend='DMDDAY' and d.fromdmdunit=f.dmdunit and d.fromdfuloc=f.loc
and d.frommodel=f.model and d.fromdmdgroup=f.dmdgroup );
1. When used dynamic sampling from level 1-3
Plan hash value: 2206240508
----------------------------------------------------------------------------------------
| Id | Operation | Name | E-Rows |E-Bytes| Cost (%CPU)| E-Time |
----------------------------------------------------------------------------------------
| 0 | DELETE STATEMENT | | 48 | 19248 | 52 (2)| 00:00:01 |
| 1 | DELETE | FCSTDRAFT | | | | |
| 2 | NESTED LOOPS | | 48 | 19248 | 52 (2)| 00:00:01 |
| 3 | VIEW | VW_SQ_1 | 32 | 11008 | 19 (6)| 00:00:01 |
| 4 | SORT UNIQUE | | 32 | 1696 | 19 (6)| 00:00:01 |
| 5 | NESTED LOOPS | | 32 | 1696 | 18 (0)| 00:00:01 |
|* 6 | TABLE ACCESS FULL| MAP | 1 | 16 | 10 (0)| 00:00:01 |
|* 7 | INDEX RANGE SCAN | DFUMAP_PK | 1165 | 43105 | 8 (0)| 00:00:01 |
|* 8 | INDEX RANGE SCAN | FCSTDRAFT_PK | 1 | 57 | 2 (0)| 00:00:01 |
----------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$75B5BFA2
3 - SEL$7D4DB4AA / VW_SQ_1@SEL$AD0B6B07
4 - SEL$7D4DB4AA
6 - SEL$7D4DB4AA / M@SEL$1
7 - SEL$7D4DB4AA / D@SEL$1
8 - SEL$75B5BFA2 / F@DEL$1
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
USE_NL(@"SEL$7D4DB4AA" "D"@"SEL$1")
LEADING(@"SEL$7D4DB4AA" "M"@"SEL$1" "D"@"SEL$1")
INDEX(@"SEL$7D4DB4AA" "D"@"SEL$1" ("DFUMAP"."MAP" "DFUMAP"."FROMDMDUNIT"
"DFUMAP"."FROMDMDGROUP" "DFUMAP"."FROMDFULOC" "DFUMAP"."FROMMODEL"
"DFUMAP"."TODMDUNIT" "DFUMAP"."TODMDGROUP" "DFUMAP"."TODFULOC"
"DFUMAP"."TOMODEL" "DFUMAP"."EFF"))
FULL(@"SEL$7D4DB4AA" "M"@"SEL$1")
USE_NL(@"SEL$75B5BFA2" "F"@"DEL$1")
LEADING(@"SEL$75B5BFA2" "VW_SQ_1"@"SEL$AD0B6B07" "F"@"DEL$1")
INDEX(@"SEL$75B5BFA2" "F"@"DEL$1" ("FCSTDRAFT"."DMDUNIT" "FCSTDRAFT"."DMDGROUP"
"FCSTDRAFT"."LOC" "FCSTDRAFT"."MODEL" "FCSTDRAFT"."STARTDATE"
"FCSTDRAFT"."TYPE" "FCSTDRAFT"."FCSTID"))
NO_ACCESS(@"SEL$75B5BFA2" "VW_SQ_1"@"SEL$AD0B6B07")
OUTLINE(@"DEL$1")
OUTLINE(@"SEL$AD0B6B07")
OUTLINE(@"SEL$1")
UNNEST(@"SEL$1")
OUTLINE_LEAF(@"SEL$75B5BFA2")
OUTLINE_LEAF(@"SEL$7D4DB4AA")
ALL_ROWS
DB_VERSION('12.1.0.2')
OPTIMIZER_FEATURES_ENABLE('12.1.0.2')
IGNORE_OPTIM_EMBEDDED_HINTS
END_OUTLINE_DATA
*/
Predicate Information (identified by operation id):
---------------------------------------------------
6 - filter("M"."U_RECONCI_CALEND"='DMDDAY' AND "M"."U_RECONCI_FREQ"='DAILY')
7 - access("M"."MAP"="D"."MAP")
8 - access("ITEM_1"="F"."DMDUNIT" AND "ITEM_4"="F"."DMDGROUP" AND
"ITEM_2"="F"."LOC" AND "ITEM_3"="F"."MODEL" AND "F"."TYPE"=4)
filter("F"."TYPE"=4)
Column Projection Information (identified by operation id):
-----------------------------------------------------------
2 - (#keys=0; cmp=6,7,8,11,13; cpy=6,7,8,9,10,12,13,14)
"ITEM_1"[VARCHAR2,200], "ITEM_2"[VARCHAR2,200], "ITEM_3"[VARCHAR2,72],
"ITEM_4"[VARCHAR2,200], "F".ROWID[ROWID,10], "F"."DMDUNIT"[VARCHAR2,200],
"F"."DMDGROUP"[VARCHAR2,200], "F"."LOC"[VARCHAR2,200], "STARTDATE"[DATE,7],
"DUR"[NUMBER,22], "F"."TYPE"[NUMBER,22], "F"."FCSTID"[VARCHAR2,200],
"F"."MODEL"[VARCHAR2,72], "F"."MARKETMGRVERSIONID"[NUMBER,22]
3 - "ITEM_1"[VARCHAR2,200], "ITEM_2"[VARCHAR2,200], "ITEM_3"[VARCHAR2,72],
"ITEM_4"[VARCHAR2,200]
4 - (#keys=4) "D"."FROMDMDUNIT"[VARCHAR2,200],
"D"."FROMDFULOC"[VARCHAR2,200], "D"."FROMMODEL"[VARCHAR2,72],
"D"."FROMDMDGROUP"[VARCHAR2,200]
5 - (#keys=0) "M"."MAP"[VARCHAR2,200], "M"."U_RECONCI_CALEND"[VARCHAR2,200],
"M"."U_RECONCI_FREQ"[VARCHAR2,200], "D".ROWID[ROWID,10],
"D"."MAP"[VARCHAR2,200], "D"."FROMDMDUNIT"[VARCHAR2,200],
"D"."FROMDMDGROUP"[VARCHAR2,200], "D"."FROMDFULOC"[VARCHAR2,200],
"D"."FROMMODEL"[VARCHAR2,72]
6 - "M"."MAP"[VARCHAR2,200], "M"."U_RECONCI_CALEND"[VARCHAR2,200],
"M"."U_RECONCI_FREQ"[VARCHAR2,200]
7 - "D".ROWID[ROWID,10], "D"."MAP"[VARCHAR2,200],
"D"."FROMDMDUNIT"[VARCHAR2,200], "D"."FROMDMDGROUP"[VARCHAR2,200],
"D"."FROMDFULOC"[VARCHAR2,200], "D"."FROMMODEL"[VARCHAR2,72]
8 - "F".ROWID[ROWID,10], "F"."DMDUNIT"[VARCHAR2,200],
"F"."DMDGROUP"[VARCHAR2,200], "F"."LOC"[VARCHAR2,200], "STARTDATE"[DATE,7],
"DUR"[NUMBER,22], "F"."TYPE"[NUMBER,22], "F"."FCSTID"[VARCHAR2,200],
"F"."MODEL"[VARCHAR2,72], "F"."MARKETMGRVERSIONID"[NUMBER,22]
Sql Plan Directive information:
-------------------------------
Valid directive ids:
6116532537563476887
Note
-----
- Warning: basic plan statistics not available. These are only collected when:
* hint 'gather_plan_statistics' is used for the statement or
* parameter 'statistics_level' is set to 'ALL', at session or system level
2. When used dynamic sampling from level 4-10
Plan hash value: 2206240508
----------------------------------------------------------------------------------------
| Id | Operation | Name | E-Rows |E-Bytes| Cost (%CPU)| E-Time |
----------------------------------------------------------------------------------------
| 0 | DELETE STATEMENT | | 10236 | 4008K| 10821 (1)| 00:00:01 |
| 1 | DELETE | FCSTDRAFT | | | | |
| 2 | NESTED LOOPS | | 10236 | 4008K| 10821 (1)| 00:00:01 |
| 3 | VIEW | VW_SQ_1 | 10489 | 3523K| 83 (2)| 00:00:01 |
| 4 | SORT UNIQUE | | 10489 | 542K| 83 (2)| 00:00:01 |
| 5 | NESTED LOOPS | | 10489 | 542K| 82 (0)| 00:00:01 |
|* 6 | TABLE ACCESS FULL| MAP | 9 | 144 | 10 (0)| 00:00:01 |
|* 7 | INDEX RANGE SCAN | DFUMAP_PK | 1165 | 43105 | 8 (0)| 00:00:01 |
|* 8 | INDEX RANGE SCAN | FCSTDRAFT_PK | 1 | 57 | 2 (0)| 00:00:01 |
----------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$75B5BFA2
3 - SEL$7D4DB4AA / VW_SQ_1@SEL$AD0B6B07
4 - SEL$7D4DB4AA
6 - SEL$7D4DB4AA / M@SEL$1
7 - SEL$7D4DB4AA / D@SEL$1
8 - SEL$75B5BFA2 / F@DEL$1
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
USE_NL(@"SEL$7D4DB4AA" "D"@"SEL$1")
LEADING(@"SEL$7D4DB4AA" "M"@"SEL$1" "D"@"SEL$1")
INDEX(@"SEL$7D4DB4AA" "D"@"SEL$1" ("DFUMAP"."MAP" "DFUMAP"."FROMDMDUNIT"
"DFUMAP"."FROMDMDGROUP" "DFUMAP"."FROMDFULOC" "DFUMAP"."FROMMODEL"
"DFUMAP"."TODMDUNIT" "DFUMAP"."TODMDGROUP" "DFUMAP"."TODFULOC"
"DFUMAP"."TOMODEL" "DFUMAP"."EFF"))
FULL(@"SEL$7D4DB4AA" "M"@"SEL$1")
USE_NL(@"SEL$75B5BFA2" "F"@"DEL$1")
LEADING(@"SEL$75B5BFA2" "VW_SQ_1"@"SEL$AD0B6B07" "F"@"DEL$1")
INDEX(@"SEL$75B5BFA2" "F"@"DEL$1" ("FCSTDRAFT"."DMDUNIT" "FCSTDRAFT"."DMDGROUP"
"FCSTDRAFT"."LOC" "FCSTDRAFT"."MODEL" "FCSTDRAFT"."STARTDATE"
"FCSTDRAFT"."TYPE" "FCSTDRAFT"."FCSTID"))
NO_ACCESS(@"SEL$75B5BFA2" "VW_SQ_1"@"SEL$AD0B6B07")
OUTLINE(@"DEL$1")
OUTLINE(@"SEL$AD0B6B07")
OUTLINE(@"SEL$1")
UNNEST(@"SEL$1")
OUTLINE_LEAF(@"SEL$75B5BFA2")
OUTLINE_LEAF(@"SEL$7D4DB4AA")
ALL_ROWS
DB_VERSION('12.1.0.2')
OPTIMIZER_FEATURES_ENABLE('12.1.0.2')
IGNORE_OPTIM_EMBEDDED_HINTS
END_OUTLINE_DATA
*/
Predicate Information (identified by operation id):
---------------------------------------------------
6 - filter("M"."U_RECONCI_CALEND"='DMDDAY' AND "M"."U_RECONCI_FREQ"='DAILY')
7 - access("M"."MAP"="D"."MAP")
8 - access("ITEM_1"="F"."DMDUNIT" AND "ITEM_4"="F"."DMDGROUP" AND
"ITEM_2"="F"."LOC" AND "ITEM_3"="F"."MODEL" AND "F"."TYPE"=4)
filter("F"."TYPE"=4)
Column Projection Information (identified by operation id):
-----------------------------------------------------------
2 - (#keys=0; cmp=6,7,8,11,13; cpy=6,7,8,9,10,12,13,14)
"ITEM_1"[VARCHAR2,200], "ITEM_2"[VARCHAR2,200], "ITEM_3"[VARCHAR2,72],
"ITEM_4"[VARCHAR2,200], "F".ROWID[ROWID,10], "F"."DMDUNIT"[VARCHAR2,200],
"F"."DMDGROUP"[VARCHAR2,200], "F"."LOC"[VARCHAR2,200], "STARTDATE"[DATE,7],
"DUR"[NUMBER,22], "F"."TYPE"[NUMBER,22], "F"."FCSTID"[VARCHAR2,200],
"F"."MODEL"[VARCHAR2,72], "F"."MARKETMGRVERSIONID"[NUMBER,22]
3 - "ITEM_1"[VARCHAR2,200], "ITEM_2"[VARCHAR2,200], "ITEM_3"[VARCHAR2,72],
"ITEM_4"[VARCHAR2,200]
4 - (#keys=4) "D"."FROMDMDUNIT"[VARCHAR2,200],
"D"."FROMDFULOC"[VARCHAR2,200], "D"."FROMMODEL"[VARCHAR2,72],
"D"."FROMDMDGROUP"[VARCHAR2,200]
5 - (#keys=0) "M"."MAP"[VARCHAR2,200], "M"."U_RECONCI_CALEND"[VARCHAR2,200],
"M"."U_RECONCI_FREQ"[VARCHAR2,200], "D".ROWID[ROWID,10],
"D"."MAP"[VARCHAR2,200], "D"."FROMDMDUNIT"[VARCHAR2,200],
"D"."FROMDMDGROUP"[VARCHAR2,200], "D"."FROMDFULOC"[VARCHAR2,200],
"D"."FROMMODEL"[VARCHAR2,72]
6 - "M"."MAP"[VARCHAR2,200], "M"."U_RECONCI_CALEND"[VARCHAR2,200],
"M"."U_RECONCI_FREQ"[VARCHAR2,200]
7 - "D".ROWID[ROWID,10], "D"."MAP"[VARCHAR2,200],
"D"."FROMDMDUNIT"[VARCHAR2,200], "D"."FROMDMDGROUP"[VARCHAR2,200],
"D"."FROMDFULOC"[VARCHAR2,200], "D"."FROMMODEL"[VARCHAR2,72]
8 - "F".ROWID[ROWID,10], "F"."DMDUNIT"[VARCHAR2,200],
"F"."DMDGROUP"[VARCHAR2,200], "F"."LOC"[VARCHAR2,200], "STARTDATE"[DATE,7],
"DUR"[NUMBER,22], "F"."TYPE"[NUMBER,22], "F"."FCSTID"[VARCHAR2,200],
"F"."MODEL"[VARCHAR2,72], "F"."MARKETMGRVERSIONID"[NUMBER,22]
Sql Plan Directive information:
-------------------------------
Valid directive ids:
6116532537563476887
Note
-----
- dynamic statistics used: dynamic sampling (level=4)
- Warning: basic plan statistics not available. These are only collected when:
* hint 'gather_plan_statistics' is used for the statement or
* parameter 'statistics_level' is set to 'ALL', at session or system level
3.When used dynamic sampling from level 11
Plan hash value: 2418933968
------------------------------------------------------------------------------------------------
| Id | Operation | Name | E-Rows |E-Bytes|E-Temp | Cost (%CPU)| E-Time |
------------------------------------------------------------------------------------------------
| 0 | DELETE STATEMENT | | 59532 | 22M| | 36989 (1)| 00:00:03 |
| 1 | DELETE | FCSTDRAFT | | | | | |
|* 2 | HASH JOIN RIGHT SEMI | | 59532 | 22M| 27M| 36989 (1)| 00:00:03 |
| 3 | VIEW | VW_SQ_1 | 81838 | 26M| | 82 (0)| 00:00:01 |
| 4 | NESTED LOOPS | | 81838 | 4235K| | 82 (0)| 00:00:01 |
|* 5 | TABLE ACCESS FULL | MAP | 9 | 144 | | 10 (0)| 00:00:01 |
|* 6 | INDEX RANGE SCAN | DFUMAP_PK | 9093 | 328K| | 8 (0)| 00:00:01 |
|* 7 | INDEX FAST FULL SCAN| FCSTDRAFT_PK | 4005K| 217M| | 24457 (1)| 00:00:02 |
------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$75B5BFA2
3 - SEL$7D4DB4AA / VW_SQ_1@SEL$AD0B6B07
4 - SEL$7D4DB4AA
5 - SEL$7D4DB4AA / M@SEL$1
6 - SEL$7D4DB4AA / D@SEL$1
7 - SEL$75B5BFA2 / F@DEL$1
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
USE_NL(@"SEL$7D4DB4AA" "D"@"SEL$1")
LEADING(@"SEL$7D4DB4AA" "M"@"SEL$1" "D"@"SEL$1")
INDEX(@"SEL$7D4DB4AA" "D"@"SEL$1" ("DFUMAP"."MAP" "DFUMAP"."FROMDMDUNIT"
"DFUMAP"."FROMDMDGROUP" "DFUMAP"."FROMDFULOC" "DFUMAP"."FROMMODEL" "DFUMAP"."TODMDUNIT"
"DFUMAP"."TODMDGROUP" "DFUMAP"."TODFULOC" "DFUMAP"."TOMODEL" "DFUMAP"."EFF"))
FULL(@"SEL$7D4DB4AA" "M"@"SEL$1")
SWAP_JOIN_INPUTS(@"SEL$75B5BFA2" "VW_SQ_1"@"SEL$AD0B6B07")
USE_HASH(@"SEL$75B5BFA2" "VW_SQ_1"@"SEL$AD0B6B07")
LEADING(@"SEL$75B5BFA2" "F"@"DEL$1" "VW_SQ_1"@"SEL$AD0B6B07")
NO_ACCESS(@"SEL$75B5BFA2" "VW_SQ_1"@"SEL$AD0B6B07")
INDEX_FFS(@"SEL$75B5BFA2" "F"@"DEL$1" ("FCSTDRAFT"."DMDUNIT" "FCSTDRAFT"."DMDGROUP"
"FCSTDRAFT"."LOC" "FCSTDRAFT"."MODEL" "FCSTDRAFT"."STARTDATE" "FCSTDRAFT"."TYPE"
"FCSTDRAFT"."FCSTID"))
OUTLINE(@"DEL$1")
OUTLINE(@"SEL$AD0B6B07")
OUTLINE(@"SEL$1")
UNNEST(@"SEL$1")
OUTLINE_LEAF(@"SEL$75B5BFA2")
OUTLINE_LEAF(@"SEL$7D4DB4AA")
ALL_ROWS
DB_VERSION('12.1.0.2')
OPTIMIZER_FEATURES_ENABLE('12.1.0.2')
IGNORE_OPTIM_EMBEDDED_HINTS
END_OUTLINE_DATA
*/
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("ITEM_1"="F"."DMDUNIT" AND "ITEM_2"="F"."LOC" AND "ITEM_3"="F"."MODEL"
AND "ITEM_4"="F"."DMDGROUP")
5 - filter("M"."U_RECONCI_CALEND"='DMDDAY' AND "M"."U_RECONCI_FREQ"='DAILY')
6 - access("M"."MAP"="D"."MAP")
7 - filter("F"."TYPE"=4)
Column Projection Information (identified by operation id):
-----------------------------------------------------------
2 - (#keys=4; cmp=1,2,3,4,7; cpy=1,2,3,4,6,8,9,10) "F"."DMDUNIT"[VARCHAR2,200],
"F"."LOC"[VARCHAR2,200], "F"."MODEL"[VARCHAR2,72], "F"."DMDGROUP"[VARCHAR2,200],
"F".ROWID[ROWID,10], "F"."MARKETMGRVERSIONID"[NUMBER,22], "F"."TYPE"[NUMBER,22],
"F"."FCSTID"[VARCHAR2,200], "STARTDATE"[DATE,7], "DUR"[NUMBER,22]
3 - "ITEM_1"[VARCHAR2,200], "ITEM_2"[VARCHAR2,200], "ITEM_3"[VARCHAR2,72],
"ITEM_4"[VARCHAR2,200]
4 - (#keys=0) "M"."MAP"[VARCHAR2,200], "M"."U_RECONCI_CALEND"[VARCHAR2,200],
"M"."U_RECONCI_FREQ"[VARCHAR2,200], "D".ROWID[ROWID,10], "D"."MAP"[VARCHAR2,200],
"D"."FROMDMDUNIT"[VARCHAR2,200], "D"."FROMDMDGROUP"[VARCHAR2,200],
"D"."FROMDFULOC"[VARCHAR2,200], "D"."FROMMODEL"[VARCHAR2,72]
5 - "M"."MAP"[VARCHAR2,200], "M"."U_RECONCI_CALEND"[VARCHAR2,200],
"M"."U_RECONCI_FREQ"[VARCHAR2,200]
6 - "D".ROWID[ROWID,10], "D"."MAP"[VARCHAR2,200], "D"."FROMDMDUNIT"[VARCHAR2,200],
"D"."FROMDMDGROUP"[VARCHAR2,200], "D"."FROMDFULOC"[VARCHAR2,200],
"D"."FROMMODEL"[VARCHAR2,72]
7 - "F".ROWID[ROWID,10], "F"."DMDUNIT"[VARCHAR2,200], "F"."DMDGROUP"[VARCHAR2,200],
"F"."LOC"[VARCHAR2,200], "STARTDATE"[DATE,7], "DUR"[NUMBER,22], "F"."TYPE"[NUMBER,22],
"F"."FCSTID"[VARCHAR2,200], "F"."MODEL"[VARCHAR2,72],
"F"."MARKETMGRVERSIONID"[NUMBER,22]
Sql Plan Directive information:
-------------------------------
Valid directive ids:
6116532537563476887
Note
-----
- dynamic statistics used: dynamic sampling (level=0)
- this is an adaptive plan
- Warning: basic plan statistics not available. These are only collected when:
* hint 'gather_plan_statistics' is used for the statement or
* parameter 'statistics_level' is set to 'ALL', at session or system level
4.When used dynamic sampling from level 12
Plan hash value: 2206240508
----------------------------------------------------------------------------------------
| Id | Operation | Name | E-Rows |E-Bytes| Cost (%CPU)| E-Time |
----------------------------------------------------------------------------------------
| 0 | DELETE STATEMENT | | 48 | 19248 | 52 (2)| 00:00:01 |
| 1 | DELETE | FCSTDRAFT | | | | |
| 2 | NESTED LOOPS | | 48 | 19248 | 52 (2)| 00:00:01 |
| 3 | VIEW | VW_SQ_1 | 32 | 11008 | 19 (6)| 00:00:01 |
| 4 | SORT UNIQUE | | 32 | 1696 | 19 (6)| 00:00:01 |
| 5 | NESTED LOOPS | | 32 | 1696 | 18 (0)| 00:00:01 |
|* 6 | TABLE ACCESS FULL| MAP | 1 | 16 | 10 (0)| 00:00:01 |
|* 7 | INDEX RANGE SCAN | DFUMAP_PK | 1165 | 43105 | 8 (0)| 00:00:01 |
|* 8 | INDEX RANGE SCAN | FCSTDRAFT_PK | 1 | 57 | 2 (0)| 00:00:01 |
----------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$75B5BFA2
3 - SEL$7D4DB4AA / VW_SQ_1@SEL$AD0B6B07
4 - SEL$7D4DB4AA
6 - SEL$7D4DB4AA / M@SEL$1
7 - SEL$7D4DB4AA / D@SEL$1
8 - SEL$75B5BFA2 / F@DEL$1
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
USE_NL(@"SEL$7D4DB4AA" "D"@"SEL$1")
LEADING(@"SEL$7D4DB4AA" "M"@"SEL$1" "D"@"SEL$1")
INDEX(@"SEL$7D4DB4AA" "D"@"SEL$1" ("DFUMAP"."MAP" "DFUMAP"."FROMDMDUNIT"
"DFUMAP"."FROMDMDGROUP" "DFUMAP"."FROMDFULOC" "DFUMAP"."FROMMODEL"
"DFUMAP"."TODMDUNIT" "DFUMAP"."TODMDGROUP" "DFUMAP"."TODFULOC"
"DFUMAP"."TOMODEL" "DFUMAP"."EFF"))
FULL(@"SEL$7D4DB4AA" "M"@"SEL$1")
USE_NL(@"SEL$75B5BFA2" "F"@"DEL$1")
LEADING(@"SEL$75B5BFA2" "VW_SQ_1"@"SEL$AD0B6B07" "F"@"DEL$1")
INDEX(@"SEL$75B5BFA2" "F"@"DEL$1" ("FCSTDRAFT"."DMDUNIT" "FCSTDRAFT"."DMDGROUP"
"FCSTDRAFT"."LOC" "FCSTDRAFT"."MODEL" "FCSTDRAFT"."STARTDATE"
"FCSTDRAFT"."TYPE" "FCSTDRAFT"."FCSTID"))
NO_ACCESS(@"SEL$75B5BFA2" "VW_SQ_1"@"SEL$AD0B6B07")
OUTLINE(@"DEL$1")
OUTLINE(@"SEL$AD0B6B07")
OUTLINE(@"SEL$1")
UNNEST(@"SEL$1")
OUTLINE_LEAF(@"SEL$75B5BFA2")
OUTLINE_LEAF(@"SEL$7D4DB4AA")
ALL_ROWS
DB_VERSION('12.1.0.2')
OPTIMIZER_FEATURES_ENABLE('12.1.0.2')
IGNORE_OPTIM_EMBEDDED_HINTS
END_OUTLINE_DATA
*/
Predicate Information (identified by operation id):
---------------------------------------------------
6 - filter("M"."U_RECONCI_CALEND"='DMDDAY' AND "M"."U_RECONCI_FREQ"='DAILY')
7 - access("M"."MAP"="D"."MAP")
8 - access("ITEM_1"="F"."DMDUNIT" AND "ITEM_4"="F"."DMDGROUP" AND
"ITEM_2"="F"."LOC" AND "ITEM_3"="F"."MODEL" AND "F"."TYPE"=4)
filter("F"."TYPE"=4)
Column Projection Information (identified by operation id):
-----------------------------------------------------------
2 - (#keys=0; cmp=6,7,8,11,13; cpy=6,7,8,9,10,12,13,14)
"ITEM_1"[VARCHAR2,200], "ITEM_2"[VARCHAR2,200], "ITEM_3"[VARCHAR2,72],
"ITEM_4"[VARCHAR2,200], "F".ROWID[ROWID,10], "F"."DMDUNIT"[VARCHAR2,200],
"F"."DMDGROUP"[VARCHAR2,200], "F"."LOC"[VARCHAR2,200], "STARTDATE"[DATE,7],
"DUR"[NUMBER,22], "F"."TYPE"[NUMBER,22], "F"."FCSTID"[VARCHAR2,200],
"F"."MODEL"[VARCHAR2,72], "F"."MARKETMGRVERSIONID"[NUMBER,22]
3 - "ITEM_1"[VARCHAR2,200], "ITEM_2"[VARCHAR2,200], "ITEM_3"[VARCHAR2,72],
"ITEM_4"[VARCHAR2,200]
4 - (#keys=4) "D"."FROMDMDUNIT"[VARCHAR2,200],
"D"."FROMDFULOC"[VARCHAR2,200], "D"."FROMMODEL"[VARCHAR2,72],
"D"."FROMDMDGROUP"[VARCHAR2,200]
5 - (#keys=0) "M"."MAP"[VARCHAR2,200], "M"."U_RECONCI_CALEND"[VARCHAR2,200],
"M"."U_RECONCI_FREQ"[VARCHAR2,200], "D".ROWID[ROWID,10],
"D"."MAP"[VARCHAR2,200], "D"."FROMDMDUNIT"[VARCHAR2,200],
"D"."FROMDMDGROUP"[VARCHAR2,200], "D"."FROMDFULOC"[VARCHAR2,200],
"D"."FROMMODEL"[VARCHAR2,72]
6 - "M"."MAP"[VARCHAR2,200], "M"."U_RECONCI_CALEND"[VARCHAR2,200],
"M"."U_RECONCI_FREQ"[VARCHAR2,200]
7 - "D".ROWID[ROWID,10], "D"."MAP"[VARCHAR2,200],
"D"."FROMDMDUNIT"[VARCHAR2,200], "D"."FROMDMDGROUP"[VARCHAR2,200],
"D"."FROMDFULOC"[VARCHAR2,200], "D"."FROMMODEL"[VARCHAR2,72]
8 - "F".ROWID[ROWID,10], "F"."DMDUNIT"[VARCHAR2,200],
"F"."DMDGROUP"[VARCHAR2,200], "F"."LOC"[VARCHAR2,200], "STARTDATE"[DATE,7],
"DUR"[NUMBER,22], "F"."TYPE"[NUMBER,22], "F"."FCSTID"[VARCHAR2,200],
"F"."MODEL"[VARCHAR2,72], "F"."MARKETMGRVERSIONID"[NUMBER,22]
Sql Plan Directive information:
-------------------------------
Valid directive ids:
6116532537563476887
Note
-----
- Warning: basic plan statistics not available. These are only collected when:
* hint 'gather_plan_statistics' is used for the statement or
* parameter 'statistics_level' is set to 'ALL', at session or system level
No comments:
Post a Comment