Re: SQL optimizer and upgrading from V5R4 to V7R1

Hi Bill

I'd say that for optimization alone, probably you don't have to do much. Now the new engine can now be used for more things - like OPNQRYF - so the use of indexes might become more important.

But for any of that, I'd say you can wait.

One thing to look at is how JOINs are processed - there was a change to a stricter process - look at the MTUs for each release in between.

HTH
Vern

On 7/21/2016 1:53 PM, Bill Howie wrote:

Hello all,

We are currently working on a project to upgrade our IBM OS from V5R4 (I
know, I know) to V7R1. One of the things that the consulting company we're
using to help us on this is saying is that we need to pay special attention
to SQL optimization and how it might change between V5R4 and V7R1. Our
opinion among the developers here is that any effect would be minimal
because we do a small amount of embedded SQL in our RPG programs and that
is about it. Wanted to throw it out to the group and see what your
comments were on this. All info is as always appreciated. Thanks!

Bill Howie