I am trying to use the plan_table to determine if a query uses a particular index. I am looking to see if the accessname field has the name of the index. I hope this is the right aproach. I am not sure how to match the queryno to the DBRM however. I converted queryno to hex and looked in the DBRM, no match. How do I use the queryno to determine which statement in the program I am looking for?

-- charles leviton (chuck_leviton@yahoo.com), September 10, 2002