2024年4月28日发(作者：)

SQL> MERGE /*+ USE_MERGE(DM TEMP) */ INTO _DP_B_TDTERM_IMEI_DAY DM

USING T_IMEI_DAY_1111 TEMP

ON(

_CD = _CD AND

_ID = _ID AND

= AND

_NBR = _NBR

)

WHEN MATCHED THEN UPDATE SET

_FLUX = _FLUX ,

_FLUX = _FLUX ,

_FLUX = _FLUX

WHEN NOT MATCHED THEN INSERT(

_CD ,

_ID ,

,

_CITY_ID ,

_ID ,

_NBR ,

_FLUX ,

_FLUX ,

_FLUX

)

VALUES(

_CD ,

_ID ,

,

_CITY_ID ,

_ID ,

_NBR ,

_FLUX ,

_FLUX ,

_FLUX

)

;

333575 rows merged.

Execution Plan

----------------------------------------------------------

Plan hash value: 2993229602

---------------------------------------------------------------------------------------------------------------------------

| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | Pstart| Pstop |

---------------------------------------------------------------------------------------------------------------------------

| 0 | MERGE STATEMENT | | 1688K| 346M| | 14060 (1)| 00:05:13 | | |

| 1 | MERGE | TW_DP_B_TDTERM_IMEI_DAY | | | | | | | |

| 2 | VIEW | | | | | | | | |

| 3 | MERGE JOIN OUTER | | 1688K| 283M| | 14060 (1)| 00:05:13 | | |

| 4 | SORT JOIN | | 264K| 28M| 68M| 2424 (1)| 00:00:54 | | |

| 5 | TABLE ACCESS FULL | T_IMEI_DAY_1111 | 264K| 28M| | 100 (2)| 00:00:03 | | |

|* 6 | SORT JOIN | | 2128K| 125M| 586M| 11636 (2)| 00:04:19 | | |

| 7 | PARTITION RANGE ALL| | 2128K| 125M| | 765 (7)| 00:00:17 | 1 | 365 |

| 8 | TABLE ACCESS FULL | TW_DP_B_TDTERM_IMEI_DAY | 2128K| 125M| | 765 (7)| 00:00:17 | 1 | 365 |

---------------------------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):

---------------------------------------------------

6 - access("DM"."USR_NBR"(+)="TEMP"."USR_NBR" AND "DM"."IMEI"(+)="TEMP"."IMEI" AND

"DM"."CITY_ID"(+)="TEMP"."CITY_ID" AND "DM"."DATE_CD"(+)="TEMP"."DATE_CD")

filter("DM"."DATE_CD"(+)="TEMP"."DATE_CD" AND "DM"."CITY_ID"(+)="TEMP"."CITY_ID" AND

"DM"."IMEI"(+)="TEMP"."IMEI" AND "DM"."USR_NBR"(+)="TEMP"."USR_NBR")

Note

-----

- dynamic sampling used for this statement

Statistics

----------------------------------------------------------

1884 recursive calls

1217983 db block gets

90427 consistent gets

654 physical reads

259129380 redo size

814 bytes sent via SQL*Net to client

2667 bytes received via SQL*Net from client

3 SQL*Net roundtrips to/from client

11 sorts (memory)

0 sorts (disk)

333575 rows processed

SQL> exit