Intrapartition parallelism with queries that reference nicknames

Intrapartition parallelism refers to the process of dividing a query into multiple concurrent parts that run in parallel by multiple processes on a single database partition.

In federated queries, the part of a query that involves local data can run in parallel while the part that involves nicknames runs serially, using a single agent process.

When multiple processors can work on the local portions of the query, the performance of queries that reference local tables and nicknames can improve.

The DFT_DEGREE database configuration parameter and the CURRENT DEGREE special register control the degree of intrapartition parallelism.