Dynamic SQL enhances performance by allowing the Replication Server Data Server Interface (DSI) module to prepare dynamic SQL statements at the replicate database and to run them repeatedly. See “Dynamic SQL for enhanced Replication Server performance,” in Chapter 4, “Performance Tuning” in the Replication Server Administration Guide Volume 2.
Replication Server 15.5 includes enhancements to dynamic SQL that:
Optimize dynamic SQL statement execution.
Utilize dynamic SQL even if the replicate minimal columns clause is used at the same time.
Extend the replicate_minimal_columns parameter to connections.
