×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Use command CHGQRYA changes to QTEMP.
CHGQRYA JOB(*) QRYOPTLIB(QTEMP)
-----Original Message-----
From: Alan Campin
Sent: Thursday, February 07, 2008 1:44 PM
To: 'midrange-l@xxxxxxxxxxxx'
Subject: Re: SQL Update Performance
<snip>
Can anyone think of a way to force CONTRCP to join position 1?
</snip>
In the QAQQINI file there is an option FORCE_JOIN_ORDER that allows you
to force the join order.
Trick is that you need to set it in the job before executing the update.
1. Make a copy of QAQQINI into QTEMP.
2. Issue update to change value of FORCE_JOIN_ORDER to *Yes.
3. Issue a Set Option to point to QAQQINI in QTEMP.
4. Run your update.
5. Change query back to pointing at original.
6. Remove copy from QTEMP or end job.
Microsoft in SQL Server has a command that does all this for you
automatically but IBM is not there yet.
I have a user defined function in the works to do this but it is not
done yet.
This mailing list archive is Copyright 1997-2024 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 on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
