RE: How to find the temporary index being used

NICE! NICE! NICE!

Wow that has so much more information!
The job name is VERY helpful since I'm the only one running the job and it's in a development Apache instance

So it could be the SQL Plan Cache getting rebuilt as well. OK.

Such fantastic information!
You all are the best!
Greg

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of stefan@xxxxxxxxxx
Sent: Tuesday, March 19, 2024 10:31 AM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: How to find the temporary index being used

Greg, once the process is "fast" again, take a look at the output of Visual Explain. It will call out any MTIs it is using.

Or use:

SELECT * FROM TABLE(QSYS2.MTI_INFO())
ORDER BY TABLE_SCHEMA,TABLE_NAME;

or
' SELECT * FROM TABLE(QSYS2.MTI_INFO())
ORDER BY REFERENCE_COUNT desc;

Best regards

Stefan