oracle添加表merge,merge更新或插入同一张表

Execution Plan

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

Plan hash value: 3989089639

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

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

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

|   0 | MERGE STATEMENT                |                          |     1 |   322 |     2   (0)| 00:00:01 |

|   1 |  MERGE                         | RI_RULE_COLLISION_DETAIL |       |       |            |          |

|   2 |   VIEW                         |                          |       |       |            |          |

|   3 |    NESTED LOOPS OUTER          |                          |     1 |   224 |     2   (0)| 00:00:01 |

|   4 |     FAST DUAL                  |                          |     1 |       |     2   (0)| 00:00:01 |

|   5 |     TABLE ACCESS BY INDEX ROWID| RI_RULE_COLLISION_DETAIL |     1 |   224 |     0   (0)| 00:00:01 |

|*  6 |      INDEX UNIQUE SCAN         | RULE_COLLISION_ID        |     1 |       |     0   (0)| 00:00:01 |

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

Predicate Information (identified by operation id):

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

6 - access("T1"."APP_NAME"(+)='GALT' AND "T1"."RULE_ID"(+)='规则一' AND "T1"."START_TIME"(+)=TO_DATE(' 2014-07-21 00:00:00', 'syyyy-mm-dd hh24:mi:ss'))

Note

-----

- dynamic sampling used for this statement (level=2)

Statistics

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

0  recursive calls

3  db block gets

2  consistent gets

0  physical reads

0  redo size

829  bytes sent via SQL*Net to client

1315  bytes received via SQL*Net from client

3  SQL*Net roundtrips to/from client

1  sorts (memory)

0  sorts (disk)

1  rows processed

这里用到的是NESTED LOOPS OUTER，不是HASH JOIN，如果是两表操作是否就不同了？这块后面还需要实验研究下，有高手可以请教请教！