Re: Recommended SQL Indexes

On 12/13/2016 10:27 AM, Jeff Young wrote:

I seem to recall discussions a while ago that mentioned that the system
created a file of recommended indexes for sql statements being executed by
various programs.
Does anyone recall what the name of this file is and where it is located?

Perhaps this would help?

http://www.ibm.com/developerworks/data/library/techarticle/dm-0701forstie/
or http://ibm.co/2gDU8xv.

david

--
David Gibbs
midrange.com

* IBM Power Systems Champion

IBM i on Power Systems: For when you can't afford to be out of business!

I'm riding a metric century (100 km / 65 miles) in the American Diabetes
Association's Tour de Cure to raise money for diabetes research, education,
advocacy, and awareness. You can make a tax deductible donation to my ride
by visiting http://lsteml.diabetessucks.net. My goal is $6000 but any
amount is appreciated.

See where I get my donations from ... visit http://lsteml.diabetessucks.ne
t/map for an interactive map (it's a geeky thing).

I may have diabetes, but diabetes doesn't have me!

--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://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