Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE employee ( firstname ) AS
SELECT CHR( 64 + level ) FROM DUAL CONNECT BY LEVEL <= 26;
26 rows affected

EXPLAIN PLAN FOR
select * from EMPLOYEE where FIRSTNAME = 'X' and rownum <5;
SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY());

PLAN_TABLE_OUTPUT

Plan hash value: 3463100252

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

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

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

|   0 | SELECT STATEMENT   |          |     1 |     4 |     3   (0)| 00:00:01 |

|*  1 |  COUNT STOPKEY     |          |       |       |            |          |

|*  2 |   TABLE ACCESS FULL| EMPLOYEE |     1 |     4 |     3   (0)| 00:00:01 |

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

Predicate Information (identified by operation id):

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

   1 - filter(ROWNUM<5)

   2 - filter("FIRSTNAME"='X')

Note

-----

   - dynamic sampling used for this statement (level=2)

EXPLAIN PLAN FOR
select * from EMPLOYEE where rownum <5 and FIRSTNAME = 'X';
SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY());

PLAN_TABLE_OUTPUT

Plan hash value: 3463100252

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

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

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

|   0 | SELECT STATEMENT   |          |     1 |     4 |     3   (0)| 00:00:01 |

|*  1 |  COUNT STOPKEY     |          |       |       |            |          |

|*  2 |   TABLE ACCESS FULL| EMPLOYEE |     1 |     4 |     3   (0)| 00:00:01 |

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

Predicate Information (identified by operation id):

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

   1 - filter(ROWNUM<5)

   2 - filter("FIRSTNAME"='X')

Note

-----

   - dynamic sampling used for this statement (level=2)