Re: RSS Visual Explain index advisor

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Not unusual....

It thinks the indexes would help, but can't know for sure until they exist.

Charles

On Thu, Feb 12, 2026 at 7:39 AM David Gibbs via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

> Folks:
>
> I'm a bit confused ... I've got a query that performs some joins and record
> selections.
>
> I ran it through visual explain (VE) and reviewed the indexes it
> recommended.
>
> I created those indexes and re-ran VE ... It no longer recommended those
> indexes, but the diagram it showed remained the same.  It appears that it
> didn't actually USE the indexes it previously recommended.
>
> When I viewed the indexes considered, the newly created indexes had a
> reason code of 4 because the cost to use the access path was higher than
> the cost of the chosen access path.
>
> Any idea why it would recommend access paths and then disregard them once
> they exist?
>
> Thanks!
>
> david
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.