Re: SQL Performance issues questions

I was using PRTSQL which did not give me enough info.

As the SELECT statements are dynamic, I ran the program and retrieved the
SQL statement from debug. I ran it in iNav with run and explain and I found
new indexes suggested which PRTSQLINF did not have. I am creating these
indexes and testing now.

What is the difference between a "regular" index which I am creating in
iNav versus a RADIX index which I see in the recommendations?

Thanks

Darryl.

On Thu, Nov 30, 2017 at 10:22 AM, D*B <dieter.bender@xxxxxxxxxxxx> wrote:

.. I've forgot:

if there's no referential constraint, you would need an index over the
join fields for both tables of your join
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-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