Table Replicated,index not used-BitOldAre both table parallel enabled? I would try making them non-parallel. I've had this problem many times. Oracle really favours full table scans when the tables are parallel enabled. Mike -- //www.freelists.org/webpage/oracle-l