Did you check MOS about Bug 13393357 filter predicate pushed into view and predicate move around for insert-as-select statementsBug 13393357 : DIFFERENT EXECUTION PLAN WHEN SELECT IS USED IN AN INSERT ?