## An example of an SQL "parallel query" SELECT /*+ full(H) parallel(H, 8) */ H.emp_no, Lookup_Emp(H.emp_no), H.hist_type, Lookup_Hist_Type(H.hist_type), count(*) FROM emp_history H GROUP BY H.emp_no, H.hist_type;