To indicate the PDQ priority of a query, a user sets the PDQPRIORITY environment variable or executes the SET PDQPRIORITY statement prior to issuing a query. In effect, the PDQ priority allows users to request a certain amount of parallel-processing resources for the query.
The resources that a user requests and the amount that the database server allocates for the query can differ. This difference occurs when the database server administrator uses the MAX_PDQPRIORITY configuration parameter to put a ceiling on user-requested resources, as the following section explains.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]