Glad you got it. Regards. >QA was cloned on early Aug, TRN was cloned on last week. The sql >statement is asking the data for the data range from 8/15 to 8/31. On >QA, there is no data to return in the merge join/hash join steps. So no >wonder it works on QA and not on TRN. joan -- //www.freelists.org/webpage/oracle-l