EXPLAIN PLAN SET STATEMENT_ID = 'Q1' FOR SELECT title FROM movie WHERE votes < 2000;

SQL> SELECT * FROM TABLE (DBMS_XPLAN. DISPLAY('plan_table','Q1'));

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------

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

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

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

|   0 | SELECT STATEMENT                    |             |    17 |   357 |    1

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
8   (0)|

|   1 |  TABLE ACCESS BY INDEX ROWID BATCHED| MOVIE       |    17 |   357 |    1
8   (0)|

|*  2 |   INDEX RANGE SCAN                  | MOVIE_VOTES |    17 |       |
2   (0)|

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


PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------

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

   2 - access("VOTES"<2000)

Note
-----
   - 'PLAN_TABLE' is old version

17 rows selected.

SQL> SELECT count(*) FROM movie WHERE votes < 2000;

  COUNT(*)
----------
      4150


SQL> SELECT count(*) FROM movie;

  COUNT(*)
----------
      9992