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.