Re: Query Performance

[Pete Hall <pbhall@xxxxxxxxxx>]

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