By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
DEPTNO | DNAME | LOC | EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM |
---|---|---|---|---|---|---|---|---|---|
20 | RESEARCH | DALLAS | 7369 | SMITH | CLERK | 7902 | 17-DEC-80 | 800 | null |
30 | SALES | CHICAGO | 7499 | ALLEN | SALESMAN | 7698 | 20-FEB-81 | 1600 | 300 |
30 | SALES | CHICAGO | 7521 | WARD | SALESMAN | 7698 | 22-FEB-81 | 1250 | 500 |
20 | RESEARCH | DALLAS | 7566 | JONES | MANAGER | 7839 | 02-APR-81 | 2975 | null |
30 | SALES | CHICAGO | 7654 | MARTIN | SALESMAN | 7698 | 28-SEP-81 | 1250 | 1400 |
30 | SALES | CHICAGO | 7698 | BLAKE | MANAGER | 7839 | 01-MAY-81 | 2850 | null |
10 | ACCOUNTING | NEW YORK | 7782 | CLARK | MANAGER | 7839 | 09-JUN-81 | 2450 | null |
20 | RESEARCH | DALLAS | 7788 | SCOTT | ANALYST | 7566 | 19-APR-87 | 3000 | null |
10 | ACCOUNTING | NEW YORK | 7839 | KING | PRESIDENT | null | 17-NOV-81 | 5000 | null |
30 | SALES | CHICAGO | 7844 | TURNER | SALESMAN | 7698 | 08-SEP-81 | 1500 | 0 |
20 | RESEARCH | DALLAS | 7876 | ADAMS | CLERK | 7788 | 23-MAY-87 | 1100 | null |
30 | SALES | CHICAGO | 7900 | JAMES | CLERK | 7698 | 03-DEC-81 | 950 | null |
20 | RESEARCH | DALLAS | 7902 | FORD | ANALYST | 7566 | 03-DEC-81 | 3000 | null |
10 | ACCOUNTING | NEW YORK | 7934 | MILLER | CLERK | 7782 | 23-JAN-82 | 1300 | null |
PLAN_TABLE_OUTPUT |
---|
SQL_ID 5kxkm1m6akx76, child number 0 |
------------------------------------- |
select * from dept join emp using(deptno) |
Plan hash value: 615168685 |
--------------------------------------------------------------------------- |
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | |
--------------------------------------------------------------------------- |
| 0 | SELECT STATEMENT | | | | 7 (100)| | |
|* 1 | HASH JOIN | | 14 | 1638 | 7 (15)| 00:00:01 | |
| 2 | TABLE ACCESS FULL| DEPT | 4 | 120 | 3 (0)| 00:00:01 | |
| 3 | TABLE ACCESS FULL| EMP | 14 | 1218 | 3 (0)| 00:00:01 | |
--------------------------------------------------------------------------- |
Predicate Information (identified by operation id): |
--------------------------------------------------- |
1 - access("DEPT"."DEPTNO"="EMP"."DEPTNO") |
Note |
----- |
- dynamic sampling used for this statement (level=2) |