Re: How to find the temporary index being used

[Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>]

More likely it’s rebuilding all of the plan cache. Rebuilding all the query access plans.   That’s normal behavior.    

The database tools in ACS would tell you if it’s building indexes but I’ll bet it’s just plan cache.  


Jim Oberholtzer
Agile Technology Architects

> On Mar 19, 2024, at 8:41 AM, Greg Wilburn <gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> I have an application that uses quite a few SQL statements... after an IPL, the process is very slow for bit.  So I'm guessing the database is building a temporary index.
>
> The question I have is how to find the one it is building.
>
> I've tried running the SQL statements in RSS with Explain, but some do inserts.
> I've looked through Index Advisor for the libraries involved and can't seem to put my finger on it.
>
> What am I missing?
>
> TIA,
> Greg
> [Logo]<https://www.totalbizfulfillment.com/>    Greg Wilburn
> Director of IT
> 301.895.3792 ext. 1231
> 301.895.3895 direct
> gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>
> 1 Corporate Dr
> Grantsville, MD 21536
> www.totalbizfulfillment.com<http://www.totalbizfulfillment.com>
> --
> 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.