oracle 执行计划消失,Oracle执行计划没有Starts列

SQL> alter session set statistics_level=all;

Session altered.

SQL> select * from emp where job='CLERK' and 1=2;

no rows selected

SQL> @dpc '' ''

PLAN_TABLE_OUTPUT

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

SQL_ID  37x6zbrbk00z6, child number 1

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

select * from emp where job='CLERK' and 1=2

Plan hash value: 3714863866

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

| Id  | Operation                    | Name    | Starts | E-Rows | Cost (%CPU)| A-Rows |   A-Time   |

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

|   0 | SELECT STATEMENT             |         |      1 |        |     1 (100)|      0 |00:00:00.01 |

|*  1 |  FILTER                      |         |      1 |        |            |      0 |00:00:00.01 |

|   2 |   TABLE ACCESS BY INDEX ROWID| EMP     |      0 |      5 |     2   (0)|      0 |00:00:00.01 |

|*  3 |    INDEX SKIP SCAN           | I_EMP_X |      0 |      5 |     1   (0)|      0 |00:00:00.01 |

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

Predicate Information (identified by operation id):

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

1 - filter(NULL IS NOT NULL)

3 - access("JOB"='CLERK')

filter("JOB"='CLERK')

22 rows selected.