Re: RSS Visual Explain index advisor

Try looking at the plan cache. It’s highly likely that an old plan cache is still influencing the results.

Remove the plan cache and see if it clears the issue.

I know, I know, any change to the SQL etc should update the plan cache, but is adding an index without changing any of the other items in the SQL going to generate a new plan cache? Force a change, then review the results….
--
Jim Oberholtzer
Agile Technology Architects

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

On Thu, Feb 12, 2026 at 8:51 AM Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

Not unusual....

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

I was under the impression that it recommends indexes based on the access
path's it has to create.

But, in retrospect, that doesn't make sense ... If it built a new access
path, that could take a massive amount of time.

Oh well.

Trust but verify.

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.