Hi Hemant The real count of rows returned by each step in the plan, is recorded there in the raw trace ("STAT #2 id=13 ===> cnt=8538 <=== .... ") >When you say " Why the returned rows are so different ..." >can you tell us the number of rows returned ? That isn't clear in >the STAT output. -- //www.freelists.org/webpage/oracle-l