Re: Query Performance

[email@xxxxxxxxxxxxxxxxxxx (James W Kilgore)]

Chuck,

AFAIK, even if you do use logicals, there's no guarantee that Query will
use it.

I think I've also read on this list that Query looks at a few of your
logicals, not all of them, before it just goes ahead and builds one.

Now the above seems to hold true if you are constantly changing your
record selection.

For more static queries, we STRDBG, change our logging level, run the
query then check the job log.
It makes logical file recommendations.

HTH

Chuck Lewis wrote:
> 
> Hi Folks !
> 
> We've got "novice" query users creating queries over a 3rd party
> applications' data base. They do a fairly good job in selection logic
> but have no real knowledge of Logical Files so they are using Physical
> Files which are NOT keyed so I am REALLY questioning the efficiency of
> some of these queries.
> 
> I know there is something called the "Predictive Query Governor" - is
> any using this or have you and is it helpful in the above scenario for
> "ratting out" problems ?
>
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---