Re: Informix and PDQ

Posted in 1997

whsmith1@compuserve.com — Tue, 01 Apr 1997 11:01:59 -0600 — source: Informix-list mailing list archive (1991-1998)

In article <19970401060701.BAA04436@ladder01.news.aol.com>, satriguy@aol.com (SaTriGuy) wrote: > > Just a comment. > > I'd suggest that anyone that is thinking of starting to turn on PDQ > initially simply set PDQ to 1. This will turn on parallel scanning for > CLIPPED . . . . . Thanks for the reminder. Parallel scans will be phase 1. Until I feel more comfortable with PDQ, I'll leave it at that. Maybe later I can experiment with resetting the MAX_PDQPRIORITY and other associated variables to produce a DSS environment during certain times, but that will come later. BTW, just for the record, PDQPRIORITY needs to be set at the SQL level, not at the engine level. I've seen things get quite scary when PDQPRIORITY is set in the ONCONFIG file. Anyone else out there have tidbits? reminders? experiences? warnings? John Carlson Informix DBA WH Smith Inc. Any of my ideas are mine alone and not necessarily those of my company. -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to Usenet