I'd like to be able to find out which queries are creating a new temporary access path during any given day. Is there an easy way to do this?
I am not aware of any easy way to do this. The simple way would be to run the queries in question and find the ones that create a temporary access path and log how many times that query is used. That would not preclude a query that does not create a temporary access path from creating one when it cannot use an access path due to system load during high use at any particular time. Some queries will always create one. Some will never create one. Some will only create one if they need it.
MORE INFORMATION ON THIS TOPIC
The Best Web Links: tips, tutorials and more.
Ask your OS/400 questions--or help out your peers by answering them--in our live OS/400 discussion forums.
Dig Deeper on Past Releases
Related Q&A from John Brandt
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.