SQL> explain plan for select * from test where flag=:a;

Explained.

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

PLAN_TABLE_OUTPUT

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

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

| Id  | Operation            |  Name       | Rows  | Bytes | Cost  |

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

|   0 | SELECT STATEMENT     |             |  3101 |  9303 |     3 |

|*  1 |  TABLE ACCESS FULL   | TEST       |  3101 |  9303 |     3 |

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

Predicate Information (identified by operation id):

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

PLAN_TABLE_OUTPUT

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

   1 - filter("TEST"."FLAG"=:Z)

Note: cpu costing is off

14 rows selected.

Execution Plan

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

   0      SELECT STATEMENT Optimizer=CHOOSE

   1    0   COLLECTION ITERATOR (PICKLER FETCH) OF 'DISPLAY'

ITPub博客

explain plan 的用法

最新文章