- запустити запит командою:
- вивести план виконання:
SQL> delete from plan_table; SQL> explain plan for select ...;
SQL> select * from table(dbms_xplan.display);
SQL> set autotrace on explain SQL> select ...; SQL> set autotrace off
Приклад:
SQL> explain plan for select * from tab;
Explained.
SQL> select * from table(dbms_xplan.display);
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Plan hash value: 457676135
--------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1146 | 98556 | 397 (5)| 00:00:02 |
| 1 | NESTED LOOPS OUTER | | 1146 | 98556 | 397 (5)| 00:00:02 |
|* 2 | TABLE ACCESS FULL | OBJ$ | 1146 | 90534 | 357 (5)| 00:00:02 |
| 3 | TABLE ACCESS CLUSTER| TAB$ | 1 | 7 | 1 (0)| 00:00:01 |
|* 4 | INDEX UNIQUE SCAN | I_OBJ# | 1 | | 0 (0)| 00:00:01 |
--------------------------------------------------------------------------------
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - filter("O"."TYPE#"<=5 AND "O"."OWNER#"=USERENV('SCHEMAID') AND
"O"."TYPE#">=2 AND "O"."LINKNAME" IS NULL)
4 - access("O"."OBJ#"="T"."OBJ#"(+))
18 rows selected.
(Як трактувати виведені дані - будемо розбиратись пізніше :)
Немає коментарів:
Дописати коментар