Parallel database query (PDQ) is an Informix database server feature that can improve performance dramatically when the database server processes queries that decision-support applications initiate. PDQ allows the database server to distribute the work for one aspect of a query among several processors. For example, if a query requires an aggregation, the database server can distribute the work for the aggregation among several processors. PDQ also includes tools for resource management.
Another database server feature, table fragmentation, allows you to store the parts of a table on different disks. PDQ delivers maximum performance benefits when the data that you query is in fragmented tables. For information on how to use fragmentation for maximum performance, see Planning a Fragmentation Strategy.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]