Kumar, attachment will be filtered in the list. please show the execution plan in both version explain plan for <your sql>; select * from table(dbms_xplan.display(null,null,'typical')); -- //www.freelists.org/webpage/oracle-l