AARGH! What you do when DBMS_XPLAN.DISPLAY_CURSOR shows a 190 line Plan with 205 entries in the Predicates section and then adds "dynamic sampling used". Just venting my frustration. Hemant K Chitale http://hemantoracledba.blogspot.com sent from my smartphone