DBMS_XPLAN.DISPLAY - predicate information

As mentioned in Oracle® Database PL/SQL Packages and Types Reference oracle predicate information is only displayed when applicable.


Do you konow when it is not applicable .



First System Which shows predicate information

SQL>  create table ttt (a number);

Table created.

SQL> explain plan for select * from ttt where a=333;

Explained.

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

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Plan hash value: 774701505

--------------------------------------------------------------------------
| Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |
--------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |      |     1 |    13 |     2   (0)| 00:00:01 |
|*  1 |  TABLE ACCESS FULL| TTT  |     1 |    13 |     2   (0)| 00:00:01 |
--------------------------------------------------------------------------

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

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

   1 - filter("A"=333)



Second System Which doesn't show predicate information