Just double checked. We're both wrong. With PDQPRIORITY zero no
parallelism is enabled. PDQPRIORITY 1 or LOW enables parallel scans
ONLY. PDQPRIORITY 2 or greater enables fragment elimination, parallel
sorting, and MGM memory use.

Art S. Kagel
Oninit

On Dec 28, 2007 10:47 AM, Gustavo Castro <gcastroc (AT) bellsouth (DOT) net
<mailto:gcastroc (AT) bellsouth (DOT) net>> wrote:
Hi

As far as I remember fragment elimination is always ON. What is
activated at PDQPRIORITY of 1 is parallel scans.

regards

Gustavo