执行计划-循环嵌套

select /*+ leading(e) use_nl(f) */ * from e,f where e.col1=f.col1;

SQL> select /*+ leading(e) use_nl(f) */ * from e,f where e.col1=f.col1;

Execution Plan
----------------------------------------------------------
Plan hash value: 3901460093

---------------------------------------------------------------------------
| Id  | Operation          | Name | Rows  | Bytes | Cost (%CPU)| Time     |
---------------------------------------------------------------------------
|   0 | SELECT STATEMENT   |      |   100 |  5100 |   770   (1)| 00:00:10 |
|   1 |  NESTED LOOPS      |      |   100 |  5100 |   770   (1)| 00:00:10 |
|   2 |   TABLE ACCESS FULL| E    |   100 |  3900 |     3   (0)| 00:00:01 |
|*  3 |   TABLE ACCESS FULL| F    |     1 |    12 |     8   (0)| 00:00:01 |
---------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   3