Re: Query; Forcing Queries to use exsisting Access Paths

["Simon Coulter" <shc@xxxxxxxxxxxxxxxxx>]

Hello  Karen,

The first thing I'd be doing is turning on debug for the job running the Query 
then run the query and 
see what the optimiser messages in the joblog have to say.  They will give you 
a pretty good idea why 
existing access paths may have been rejected and why query decided to behave in 
whatever way it did.

Regards,
Simon Coulter.

//----------------------------------------------------------
// FlyByNight Software         AS/400 Technical Specialists
// Phone: +61 3 9419 0175      Mobile: +61 0411 091 400
// Fax:   +61 3 9419 0175      E-mail: shc@flybynight.com.au
// 
// Windoze should not be open at Warp speed.
X-Mailer: Internet Mail Service (5.5.2232.9)
Date: Sun, 03 Jan 99 20:06:18 -0800
From: "Karen Burke" <kburke@startel.com>
To: "'MIDRANGE-L@midrange.com'" <MIDRANGE-L@midrange.com>
Reply-To: MIDRANGE-L@midrange.com
Subject: Query; Forcing Queries to use exsisting Access Paths
M 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

Title: Query; Forcing Queries to use exsisting Access Paths

R!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">

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