Doing some tracing, looking at AWR, execution plans. I see that the merge is now doing FTS on the archive tables where it was using indexes before. Any way to force it to use the primary key index like it was before the upgrade? Sandy Transzap, Inc. -- //www.freelists.org/webpage/oracle-l