|
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.
|
