Mike,

I am not quite familiar with IOT, I thought it is only for small static tables. Besides, after adding the index, this query still use HASH JOIN, how is the performance of HASH JOIN compared with NESTED LOOP?

Thanks