Re: Looking for file structure details

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Just curious, Dan - did you eventually get index advice that DID help? 
From Navigator, that is?

On 6/27/2015 1:23 PM, Dan wrote:
> Jon, thank you for sharing this!  I'd been off the Power i radar for
> several years prior to January, and I'd not heard this.  I used debug a few
> months ago to get index advice and wondered why it didn't seem to give good
> results.  (At the time, the admins had not opened the ports for System
> Navigator, so I was stuck with debug.)  Very good information.
>
> - Dan
>
> On Sat, Jun 27, 2015 at 9:31 AM, Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:
>
> > According to the information I’ve been given in recent years by IBM’s
> > database experts such as Mike Cain, Kent Milligan and others it is becoming
> > increasingly risky to base decisions on creating new indexes etc. on the
> > debug information. It is many, many years since the debug information has
> > been updated and consequently the decisions being made by the optimizer are
> > not adequately reflected.
> >
> > As Vern says, Visual Explain is the best and in practice should probably
> > be the only tool you use.
> >
> > Jon Paris