子查询非嵌套(subquery unnesting) FILTER

SQL> set linesize 200
SQL> set pagesize 200
SQL> explain plan for select * from test1 where owner='SCOTT' or object_id in (select object_id from test2 where owner='SCOTT');

已解释。

SQL> select * from table(dbms_xplan.display());

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Plan hash value: 1896454807

----------------------------------------------------------------------------
| Id  | Operation	   | Name  | Rows  | Bytes | Cost (%CPU)| Time	   |
----------------------------------------------------------------------------
|   0 | SELECT STATEMENT   |	   |  6171 |  1247K|   348   (1)| 00:00:05 |
|*  1 |  FILTER 	   |	   |	   |	   |		|	   |
|   2 |   TABLE ACCESS FULL| TEST1 |   103K|	20M|   348   (1)| 00:00:05 |
|*  3 |   TABLE ACCESS FULL| TEST2 |	 1 |	30 |