Database Reference
In-Depth Information
Predicate Information (identified by operation id):
---------------------------------------------------
2 - filter("N"<=19 AND "N">=6)
Column Projection Information (identified by operation id):
-----------------------------------------------------------
1 - (#keys=0) COUNT(*)[22]
The following queries show how to use modifiers to add or remove information from the default output
generated by the primitive values
basic
and
typical
. Because they're based on the same query as the previous
examples, you can compare the outputs to see what's different. This is an excerpt of the output generated by the
display.sql
script:
SQL> SELECT * FROM table(dbms_xplan.display(NULL, NULL, '
basic +predicate
'));
PLAN_TABLE_OUTPUT
-----------------------------------
Plan hash value: 2966233522
-----------------------------------
| Id | Operation | Name |
-----------------------------------
| 0 | SELECT STATEMENT | |
| 1 | SORT AGGREGATE | |
|* 2 | TABLE ACCESS FULL| T |
-----------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - filter("N"<=19 AND "N">=6)
SQL> SELECT * FROM table(dbms_xplan.display(NULL, NULL, '
typical -bytes -note
'));
PLAN_TABLE_OUTPUT
-------------------------------------------------------------------
Plan hash value: 2966233522
-------------------------------------------------------------------
| Id | Operation | Name | Rows | Cost (%CPU)| Time |
-------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 2 (0)| 00:00:01 |
| 1 | SORT AGGREGATE | | 1 | | |
|* 2 | TABLE ACCESS FULL| T | 15 | 2 (0)| 00:00:01 |
-------------------------------------------------------------------