-- An invalid parallel hint
select /*+ first_rows_10 index (emp emp_idx) parallel(emp,8)*/ 
   emp_name 
from 
   emp 
where
   emp_type = 'SALARIED';


select /*+ FULL(emp) PARALLEL(emp, 35) */



select /*+ PARALLEL(employees 4) PARALLEL(departments 4) 
USE_HASH(employees) ORDERED */ 
   max(salary), 
   avg(salary)
from 
   employees, 
   departments
where
   employees.department_id = departments.department_id 
group by 
   employees.department_id;




select /*+ PARALLEL(employees 4) PARALLEL(departments 4) 
USE_HASH(employees) ORDERED */ 
   max(salary), 
   avg(salary)
from 
   employees, 
   departments
where
   employees.department_id = departments.department_id 
group by 
   employees.department_id;


select /*+ PARALLEL(employees 4) PARALLEL(departments 4) USE_HASH(employees) ORDERED */ 
   max(salary), 
   avg(salary)
from 
   employees, 
   departments
where
   employees.department_id = departments.department_id 
group by 
   employees.department_id;