Re: Query; Forcing Queries to use exsisting Access Paths

>
>
>I heard someone mention an AS400 Query guru. They talked about forcing
>queries to use exsisting access paths, how do you do this? We run 25
>queries daily to build a data file for our users to query at my
>company--this takes 3 to 4 hours to run and if possible ofcourse we would
>like to save time. I took out all sort references like recommended and
>didn't seem to gain much time. We are running V4 R1.
>
>
>Thanks in advance for any help.
>Karen Burke
>kburke@startel.com 


The only way to guarantee that Query uses the optimum access path is to
specify the LF instead of the PF in defining your Query.  And I'm not sure
if that will prevent the Query Optimizer from changing things on you.

[Donning asbestos and other insulating garments]

If you can, try to pare down your data, creating work files with -just- the
data you need.  Don't use more than 1 or 2 files in a query; IMHO more
files make more trouble!  Try to keep the select/omit on the primary
(first) file.


And, no, you may NOT borrow our guru!  (:


--Paul E Musselman
PaulMmn@ixnetcom.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
+---