Hi Raj >Christian, RULE hint didn't help either. The RBO doesn't use the histograms. Therefore, IMO, your "problem" isn't = caused by histograms... HTH Chris -- http://www.freelists.org/webpage/oracle-l