Parallelism with queries that reference nicknames

Queries that contain nicknames can participate in three types of intra-query parallelism.

The three types of intra-query parallelism are:
  • Intrapartition query parallelism on single partition, multiprocessor configurations
  • Interpartition query parallelism on multiple partition configurations
  • Mixed query parallelism that consists of both intrapartition and interpartition parallelism where each partition runs on an SMP computer