Every day is a school day. I just found out the hard way that trace point OP167 doesn't only turn off K-joins, it also turns off T-joins. For bonus points the displayed QEP showed a T-join still being used, so it took me about 15 minutes to realize why it was taking 92 seconds and 630,000 DIOs to locate a row using a hash index. Roy