RE: SQL Performance issues questions

Darryl:

There is not a difference. The "regular" index is a RADIX type of index.
You might see a request for an "Encoded Vector Index" (EVI) depending on the
cardinality of the column you are using. EVI is a different (and very cool)
index.

You might be considering the difference between a logical file and index. A
logical file is a combination of an SQL Index and an SQL view in SQL terms
and is a hybrid object.


--
Jim Oberholtzer
Agile Technology Architects


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of a4g
atl
Sent: Thursday, November 30, 2017 11:21 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: 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

--
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