• Subject: Re: Query; Forcing Queries to use exsisting Access Paths
  • From: "Simon Coulter" <shc@xxxxxxxxxxxxxxxxx>
  • Date: Tue, 05 Jan 99 09:05:51 +0100

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 


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact [javascript protected email address].