ORACLE11G优化器对full Outer join 的加强

1 降级优化器到10.2

SQL> alter system set optimizer_features_enable        ='10.2.0.2' scope=memory ;


System altered.

2 执行全外连接语句
SQL> set autotrace trace 
SQL> set pagesize 200
SQL> set linesize 200
SQL> select *
  2    from ESTIMATES e
  3    full outer join ACTUALS a on e.ITEM_NBR = a.ITEM_NBR ;


8 rows selected.




Execution Plan
----------------------------------------------------------
Plan hash value: 2047377711


----------------------------------------------------------------------------------
| Id  | Operation            | Name      | Rows  | Bytes | Cost (%CPU)| Time     |
----------------------------------------------------------------------------------
|   0 | SELECT STATEMENT     |           |     7 |   406 |    13   (8)| 00:00:01 |
|   1 |  VIEW                |           |     7 |   406 |    13   (8)| 00:00:01 |
|   2 |   UNION-ALL          |           |       |