yeah, statistics have been gathered.
I'll run execution plan on 9i. (i joined company just a couple months ago when they were in the middle of the project)
The 10g plan is full of full table scans on the biggest table.