Oracle中可被并行化执行的SQL操作

并不是所有的SQL operations都是可并行化的；不少人认为sort merge join这种排序合并操作是不能并行化的，这显示是一种错误的认识。有了这样一个列表你就可以更好地理解Oracle中的Parallel Execution了：

Parallel Query:
Table scan
Nested loop join
Sort merge join
NOT IN
GROUP BY
Hash join
SELECT DISTINCT
UNION and UNION ALL
Aggregation
PL/SQL functions called from SQL
ORDER BY

DDL:
CREATE TABLE AS SELECT
CREATE INDEX
Rebuild index
Move partition
Split partition

DML:
UPDATE   on partitioned table
DELETE   on partitioned table
MERGE    on partitioned table
INSERT … SELECT
Enable constraint (the table scan is parallelized)
Star transformation

© 2011, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.

相关文章 | Related posts:

1. Optimizer Selects the Merge Join Cartesian Despite the Hints
2. 如何设计分区索引
3. Wrong Results from a RANGE-LIST PARTITIONED TABLE- Bug 5882821
4. Diagnosing ORA-14097 On Alter Table Exchange Partition
5. Script:列出数据库中子表上没有对应索引的外键
6. 11.2 Database New Feature Deferred Segment Creation
7. Script:partition table into rowid extent chunks
8. How To Introduce Interval Parititioning into a Range Partitioned Table
9. EVENT: 10060 dump predicates in optimizer (kko)
10. How to Re-Organize a Table Online