Oracle Parallel Execution of SQL Statements

发布时间：2020-12-12 15:34:01 所属栏目：百科来源：网络整理

导读：oracle 当查询比较慢的时候，可以考虑并发查询，可以很快出结果，预计比之前不加快2-4倍。 Parallel Query Intra- and Inter-Operation ExampleAs an example of parallel query with intra- and inter-operation parallelism,consider a more complex query

oracle 当查询比较慢的时候，可以考虑并发查询，可以很快出结果，预计比之前不加快2-4倍。

Parallel Query Intra- and Inter-Operation Example

As an example of parallel query with intra- and inter-operation parallelism,consider a more complex query:

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;

http://docs.oracle.com/cd/B10500_01/server.920/a96524/c20paral.htm

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!