EXPLAIN PLAN FOR
SELECT DEPARTMENT_ID, MANAGER_ID FROM EMPLOYEES
GROUP BY DEPARTMENT_ID, MANAGER_ID ;
SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);
'Oracle' 카테고리의 다른 글
| 실행계획 (0) | 2017.03.06 |
|---|---|
| START WITH CONNECT BY (0) | 2017.02.23 |
| OVER PARTITION BY (0) | 2017.02.22 |
| EXISTS (0) | 2017.02.21 |
| rowid (0) | 2017.02.14 |