Parallel Processing
XPS supports parallelism for a number of SQL operations, including scans, joins, sorts, aggregation, group-bys, loads, inserts, and index builds. In the final section we consider the query parallelism supported by XPS and look at colocated joins—one of the challenges of parallel query processing that is based on a shared-nothing model.
Query Parallelism
The Parallel Database Query (PDQ) feature of XPS improves the performance of individual queries. PDQ allows the database to carry out parallel scans of fragments in a single coserver or fragments spread across multiple coservers. A query plan is first broken up into subplans to speed execution. The subplans are then allocated to a number of threads and processed in parallel. ...
Get Configuring and Tuning Databases on the Solaris™ Platform now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
