query.sql

EXPLAIN PLAN FOR 
  SELECT NAME, sum(salary)
  FROM   HR.S_EMP e, HR.S_DEPT d
  WHERE  d.ID = e.DEPT_ID
  GROUP BY NAME;

SELECT 
  OPERATION,
  OBJECT_OWNER,
  OBJECT_NAME,
  OPTIMIZER,
  FILTER_PREDICATES,
  PROJECTION
FROM PLAN_TABLE;

SELECT NAME, sum(salary)
FROM   HR.S_EMP e, HR.S_DEPT d
WHERE  d.ID = e.DEPT_ID
GROUP BY NAME;

EXPLAIN PLAN FOR 
  SELECT /*+ parallel(4) full(e) full(d) */ NAME, sum(salary)
  FROM   HR.S_EMP e, HR.S_DEPT d
  WHERE  d.ID = e.DEPT_ID
  GROUP BY NAME;
  
SELECT 
  OPERATION,
  OBJECT_OWNER,
  OBJECT_NAME,
  OPTIMIZER,
  FILTER_PREDICATES,
  PROJECTION
FROM PLAN_TABLE;