Re: Looking for file structure details

[Dan <dan27649@xxxxxxxxx>]

No.  I finished up the project before I was able to use Navigator.  Not
sure I would have checked, because, before today, I presumed the advice
between debug and Visual Explain would be identical.

- Dan

On Sat, Jun 27, 2015 at 4:05 PM, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
wrote:

> 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