create bitmap index oo_IDX on o(o2.id)
from o,o2
where o.id=o2.id;
from o,o2
where o.id=o2.id;
-------------------------------------------------------------
join_index='Y' or 'NO'
-------------------------------------------------------------
join_index='Y' or 'NO'