[Fwd: RE: IDS Features - MAX_PDQPRIORITY]

Posted in 2007

Art S. Kagel (Oninit LLC) — Mon, 31 Dec 2007 14:09:04 -0500 — source: Usenet: comp.databases.informix

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@bellsouth.net <mailto:gcastroc@bellsouth.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