DB2_INLIST_TO_NLJN --- the registry variable
This will convert the IN List to a NLJN and can force the usage of the index"
What is the internal structure of this registry variable. Does it creat a temp table for the IN predicted values on the fly.
How does it works?