Informix Parallel Database Query

Introduction

PDQ stands for Parallel Database Query. It accomplishes complex SQL operations in parallel across several processors, thus reducing the execution time. PDQ breaks down large query operations into small tasks, so that multiple threads can execute their portion of the large task in parallel. The tasks that can be executed in parallel are scan queries, joins, sorts, aggregates, groups, delete, insert, and index creation operations.

PDQ Architecture

Applications Supported in Informix DSA

PDQ Administration

PDQ and Stored Procedures

Who Controls PDQ Resources?

The Optimizer Compare Index Parameter

Understanding the SET EXPLAIN Functionality

Bibliography
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-Share Alike 2.5 License.