I've completed a test and verified that Logical Standby is not doing full table scans. Yes, it does convert the single update statement (update table_name set newcolumn=existingcolumn) to individual row-level update statements. When I ran one of those update statements through Explain Plan, it showed that it would do a full table scan, but when I actually looked in v$sql_plan for the statement currently executing, I could see that it is indeed doing an index unique scan. Oracle Support provided some better settings for SQL Apply parameters and that seems to be helping, but it still takes about 4 minutes for SQL Apply to chew through each 10-Mb archived log. At this rate, it would take about 30 hours to get through them all. This would not be tolerable in Production if we were relying on our Production Logical Standby for reporting. -- //www.freelists.org/webpage/oracle-l