Try to find the appropriate access plan(s) in the SQE plan cache and delete
it from the plan cache.
If no access plan exists any more it is built by scratch.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Mathias
Langlet
Sent: Freitag, 3. Februar 2017 17:28
To: rpg400-l@xxxxxxxxxxxx
Subject: Force rebuild of SQL Access Plan?
Hi all,
I?m having trouble with a dynamic query on our production server being run
in one of our SQLRPGLE programs. All indices used by the query exists on
both our development system and production system. The data contents of the
tables are essentially the same but the access path on the production system
is using a table scan instead of an index probe.
We changed the query to do a ?in(subselect union subselect)? instead of a
?in (subselect) or in(subselect)? and this allowed the query to run with the
correct index. But we don?t want to change the embedded SQL in the program,
just force the DBMS to rebuild the access path of the ?in (subselect) or
in(subselect)? query.
Is this possible? If so how?
Thanks and Regards,
Mathias
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
