Hint Report (identified by operation id / Query Block Name / Object Alias): Total hints for statement: 76 (U - Unused (7), N - Unresolved (44)) --------------------------------------------------------------------------- 0 - STATEMENT - ALL_ROWS - DB_VERSION('19.1.0') - IGNORE_OPTIM_EMBEDDED_HINTS - OPTIMIZER_FEATURES_ENABLE('19.1.0') 0 - SEL$0F3929D0 N - FULL(@"SEL$0F3929D0" "MDD"@"SET$9A7C2438_1") N - FULL(@"SEL$0F3929D0" "MTD"@"SET$9A7C2438_1") N - LEADING(@"SEL$0F3929D0" "REF1"@"SET$9A7C2438_1" "MDD"@"SET$9A7C2438_1" "REF2"@"SET$9A7C2438_1" "MTD"@"SET$9A7C2438_1") N - PX_JOIN_FILTER(@"SEL$0F3929D0" "MTD"@"SET$9A7C2438_1") N - SWAP_JOIN_INPUTS(@"SEL$0F3929D0" "REF2"@"SET$9A7C2438_1") N - USE_HASH(@"SEL$0F3929D0" "MTD"@"SET$9A7C2438_1") N - USE_HASH(@"SEL$0F3929D0" "REF2"@"SET$9A7C2438_1") N - USE_NL(@"SEL$0F3929D0" "MDD"@"SET$9A7C2438_1") 0 - SEL$0FA1E029 N - MERGE(@"SEL$0FA1E029" >"SEL$3B8FD131") 0 - SEL$4119B633 N - MERGE(@"SEL$4119B633" >"SEL$FBFF865E") 0 - SEL$583AEB9A N - FULL(@"SEL$583AEB9A" "MDD"@"SET$9A7C2438_2") N - FULL(@"SEL$583AEB9A" "MTD"@"SET$9A7C2438_2") N - LEADING(@"SEL$583AEB9A" "REF1"@"SET$9A7C2438_2" "MDD"@"SET$9A7C2438_2" "REF2"@"SET$9A7C2438_2" "MTD"@"SET$9A7C2438_2") N - PX_JOIN_FILTER(@"SEL$583AEB9A" "MTD"@"SET$9A7C2438_2") N - SWAP_JOIN_INPUTS(@"SEL$583AEB9A" "REF2"@"SET$9A7C2438_2") N - USE_HASH(@"SEL$583AEB9A" "MTD"@"SET$9A7C2438_2") N - USE_HASH(@"SEL$583AEB9A" "REF2"@"SET$9A7C2438_2") N - USE_NL(@"SEL$583AEB9A" "MDD"@"SET$9A7C2438_2") 0 - SEL$9FA593F3 N - FULL(@"SEL$9FA593F3" "MDD"@"SET$136C5676_2") N - FULL(@"SEL$9FA593F3" "MTD"@"SET$136C5676_2") N - LEADING(@"SEL$9FA593F3" "REF1"@"SET$136C5676_2" "MDD"@"SET$136C5676_2" "REF2"@"SET$136C5676_2" "MTD"@"SET$136C5676_2") N - PX_JOIN_FILTER(@"SEL$9FA593F3" "MTD"@"SET$136C5676_2") N - SWAP_JOIN_INPUTS(@"SEL$9FA593F3" "REF2"@"SET$136C5676_2") N - USE_HASH(@"SEL$9FA593F3" "MTD"@"SET$136C5676_2") N - USE_HASH(@"SEL$9FA593F3" "REF2"@"SET$136C5676_2") N - USE_NL(@"SEL$9FA593F3" "MDD"@"SET$136C5676_2") 0 - SEL$AE92F862 N - MERGE(@"SEL$AE92F862" >"SEL$AAA06791") 0 - SEL$BBC9940B N - MERGE(@"SEL$BBC9940B" >"SEL$9C1508C7") 0 - SEL$CE6FF33E N - FULL(@"SEL$CE6FF33E" "EDCP"@"SET$136C5676_2") N - LEADING(@"SEL$CE6FF33E" "VW_JF_SET$CB26004B"@"SEL$D6577BAE" "EDCP"@"SET$136C5676_2") N - USE_HASH(@"SEL$CE6FF33E" "EDCP"@"SET$136C5676_2") 0 - SEL$F61B142F N - FULL(@"SEL$F61B142F" "EDCP"@"SET$9A7C2438_2") N - LEADING(@"SEL$F61B142F" "VW_JF_SET$CE5EDD29"@"SEL$D53A378B" "EDCP"@"SET$9A7C2438_2") N - USE_HASH(@"SEL$F61B142F" "EDCP"@"SET$9A7C2438_2") 0 - SEL$FED9171C N - FULL(@"SEL$FED9171C" "MDD"@"SET$136C5676_1") N - FULL(@"SEL$FED9171C" "MTD"@"SET$136C5676_1") N - LEADING(@"SEL$FED9171C" "REF1"@"SET$136C5676_1" "MDD"@"SET$136C5676_1" "REF2"@"SET$136C5676_1" "MTD"@"SET$136C5676_1") N - PX_JOIN_FILTER(@"SEL$FED9171C" "MTD"@"SET$136C5676_1") N - SWAP_JOIN_INPUTS(@"SEL$FED9171C" "REF2"@"SET$136C5676_1") N - USE_HASH(@"SEL$FED9171C" "MTD"@"SET$136C5676_1") N - USE_HASH(@"SEL$FED9171C" "REF2"@"SET$136C5676_1") N - USE_NL(@"SEL$FED9171C" "MDD"@"SET$136C5676_1") 0 - SET$136C5676 N - FACTORIZE_JOIN(@"SET$136C5676"("EDCP"@"SET$136C5676_2" "EDCP"@"SET$136C5676_1")) 0 - SET$9A7C2438 N - FACTORIZE_JOIN(@"SET$9A7C2438"("EDCP"@"SET$9A7C2438_2" "EDCP"@"SET$9A7C2438_1")) 2 - SEL$1 U - materialize / rejected by IGNORE_OPTIM_EMBEDDED_HINTS - MATERIALIZE(@"SEL$1") 3 - SEL$1 / ESSC@SEL$1 - INDEX_RS_ASC(@"SEL$1" "ESSC"@"SEL$1" ("ESSC"."BTID")) 5 - SEL$2 U - leading(REF1 BFID_STG VCD_STG) / rejected by IGNORE_OPTIM_EMBEDDED_HINTS U - materialize / rejected by IGNORE_OPTIM_EMBEDDED_HINTS - MATERIALIZE(@"SEL$2") - LEADING(@"SEL$2" "REF1"@"SEL$2" "BFID_STG"@"SEL$2" "VCD_STG"@"SEL$2") 12 - SEL$2 / BFID_STG@SEL$2 - FULL(@"SEL$2" "BFID_STG"@"SEL$2") - USE_NL(@"SEL$2" "BFID_STG"@"SEL$2") 15 - SEL$2 / VCD_STG@SEL$2 U - use_hash(VCD_STG) / rejected by IGNORE_OPTIM_EMBEDDED_HINTS - FULL(@"SEL$2" "VCD_STG"@"SEL$2") - PX_JOIN_FILTER(@"SEL$2" "VCD_STG"@"SEL$2") - USE_HASH(@"SEL$2" "VCD_STG"@"SEL$2") 27 - SEL$D67CB2D2 / T1@SEL$D67CB2D2 - FULL(@"SEL$D67CB2D2" "T1"@"SEL$D67CB2D2") 31 - SEL$EC770CBA / T1@SEL$EC770CBA - FULL(@"SEL$EC770CBA" "T1"@"SEL$EC770CBA") 42 - SEL$D67CB2D3 / T1@SEL$D67CB2D3 - FULL(@"SEL$D67CB2D3" "T1"@"SEL$D67CB2D3") 46 - SEL$EC770CBB / T1@SEL$EC770CBB - FULL(@"SEL$EC770CBB" "T1"@"SEL$EC770CBB") 51 - SET$A43F0C1D_3 - OR_EXPAND(@"SET$CD5DAC4C_1" (1) (2)) 57 - SEL$D67CB2D4 / T1@SEL$D67CB2D4 - FULL(@"SEL$D67CB2D4" "T1"@"SEL$D67CB2D4") 61 - SEL$EC770CBC / T1@SEL$EC770CBC - FULL(@"SEL$EC770CBC" "T1"@"SEL$EC770CBC") 74 - SEL$D67CB2D5 / T1@SEL$D67CB2D5 - FULL(@"SEL$D67CB2D5" "T1"@"SEL$D67CB2D5") 78 - SEL$EC770CBD / T1@SEL$EC770CBD - FULL(@"SEL$EC770CBD" "T1"@"SEL$EC770CBD") 98 - SET$B8B9E081_3 U - leading (REF1 REF2 MDD EDCP MTD ) / rejected by IGNORE_OPTIM_EMBEDDED_HINTS - OR_EXPAND(@"SET$CD5DAC4C_2" (1) (2)) 106 - SET$B8B9E081_3 / MDD@SET$B8B9E081_3 U - EXPAND_TABLE(@"SEL$3" "MDD"@"SEL$3") U - EXPAND_TABLE(@"SEL$3" "MDD"@"SEL$3") / hint overridden by another in parent query block 113 - SEL$4 - no_unnest 113 - SEL$4 / SPPEC@SEL$4 - FULL(@"SEL$4" "SPPEC"@"SEL$4") Note ----- - dynamic statistics used: statistics for conventional DML - SQL profile "coe_XXXXXXX_287234505" used for this statement - Failed to use SQL plan baseline for this statement