Database Reference
In-Depth Information
SQL> SELECT *
2 FROM t1, t2
3 WHERE t1.id = t2.id
4 AND t1.n = 666;
SQL> SELECT *
2 FROM table(dbms_xplan.display_cursor(format=>'basic +predicate +note +adaptive +
report
'));
EXPLAINED SQL STATEMENT:
------------------------
SELECT * FROM t1, t2 WHERE t1.id = t2.id AND t1.n = 666
Plan hash value: 1837274416
-------------------------------------------------
| Id | Operation | Name |
-------------------------------------------------
| 0 | SELECT STATEMENT | |
|- * 1 | HASH JOIN | |
| 2 | NESTED LOOPS | |
| 3 | NESTED LOOPS | |
|- 4 | STATISTICS COLLECTOR | |
| * 5 | TABLE ACCESS FULL | T1 |
| * 6 | INDEX UNIQUE SCAN | T2_PK |
| 7 | TABLE ACCESS BY INDEX ROWID| T2 |
|- 8 | TABLE ACCESS FULL | T2 |
-------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - access("T1"."ID"="T2"."ID")
5 - filter("T1"."N"=666)
6 - access("T1"."ID"="T2"."ID")
Note
-----
- this is an adaptive plan (rows marked '-' are inactive)
Adaptive plan:
-------------
This cursor has an adaptive plan, but adaptive plans are enabled for
reporting mode only. The plan that would be executed if adaptive plans
were enabled is displayed below.
Plan hash value: 1837274416
