Hi Mohamed, This is the very valid points. However what bugs me is the fact that unusable index seems valid to optimizer to do left-join elimination. And I cannot find it to be written somewhere that non-atomic refresh makes no promises in case of errors during refresh. -- //www.freelists.org/webpage/oracle-l