Re: Query Performance

[Chuck Lewis <clewis@xxxxxxxxxx>]

Thanks Guys !

I'll try that.

Neither of you played around with Predictive Query Governor or ever heard of it 
?
Know it's been around for awhile but also know that in general it's been one of
those "well hidden secrets".

Chuck


Pete Hall wrote:

> At 08:20 09/10/1999 , Chuck Lewis wrote:
> >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 ?
>
> The AS/400 will use the proper access path. You just need to make sure that
> it exists. This often means running the most common queries in debug,
> examining the job log and creating whatever indexes are needed.
>
> Pete Hall
> pbhall@execpc.com
> http://www.execpc.com/~pbhall
> +---
> | 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
> +---

+---
| 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
+---