S ymmetric multiprocessors (SMPs), clusters, or massively parallel systems ![]() Parallel execution benefits systems with all of the following characteristics: For example, you can use parallel execution to access large objects (LOBs). You can also use parallel execution to access object types within an Oracle database. Queries requiring large table scans, joins, or partitioned index scansĬreation of large tables (including materialized views)īulk inserts, updates, merges, and deletes Parallel execution improves processing for: In this case, each quarter will be a partition, a smaller and more manageable unit of an index or table. ![]() The improvement in performance can be quite high. An example of this is when four processes handle four different quarters in a year instead of one process handling all four quarters by itself. Simply expressed, parallelism is the idea of breaking down a task so that, instead of one process doing all of the work in a query, many processes do part of the work at the same time. Parallel execution is sometimes called parallelism. You can also implement parallel execution on certain types of online transaction processing (OLTP) and hybrid systems. Parallel execution dramatically reduces response time for data-intensive operations on large databases typically associated with decision support systems (DSS) and data warehouses. Introduction to Parallel Execution Tuning
0 Comments
Leave a Reply. |