Re: Advised Indexes since 7.3 upgrade

"account numbers (Approx 185K), dates, and other high key cardinality"
"25 million rows"

Not Sure I'd call 185K out of 25M "high cardinality"...

IBM has recent enhancements that allow for EVI only access, that might be
why your seeing more request.



Charles


On Fri, Aug 31, 2018 at 10:09 AM Jack Prucha <Jack.Prucha@xxxxxxx> wrote:

There's been a marked change in the number of EVI indexes advised since
7.3 was installed. I cleared the advised indexes for one library before
the nightly batch run. Afterwards were the expected Times Advised
quantities of up to around 60 except for two EVIs which were advised 79K
times! Some of the advised EVI indexes have high expensive query
estimates.

Also the advised indexes are not what are classically (what Dan Cruikshank
taught us in SQL Tuning and Monitoring Workshop) used for EVIs. These are
account numbers (Approx 185K), dates, and other high key cardinality fields.

Has anyone else had similar results since 7.3?

Has the general rule changed for best practices use of EVIs and Radix
indexes?

One of the files in question is around 25 million rows so I don't want to
waste a lot time building indexes that aren't that useful.

Thanks in advance.

Jack Prucha
Programming Team Supervisor

College Foundation, Inc.
Office Phone: 919.835.2530

This email, including any documents, files, or previous email messages
attached to it, has been sent from an email account of College Foundation
Inc., (CFI) and may contain confidential, proprietary, or legally
privileged information belonging to CFI. If you are not the intended
recipient, any dissemination, distribution, or copying of this email or its
attachments is strictly prohibited. If you have received this email in
error, please immediately notify the sender by email and destroy the
original email and any attachments.
--
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