Difference between revisions of "Oracle Administration Manage Parallel Processing"

From Robs_Wiki
Jump to: navigation, search
(Created page with "__TOC__ == Use a hint to force parallel processing == <pre> SELECT + PARALLEL(employees 4) PARALLEL(departments 4) USE_HASH(employees) ORDERED: MAX(salary), AVG(salary) F...")
 
(No difference)

Latest revision as of 14:26, 15 August 2019

Use a hint to force parallel processing

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;