SQL Server 2014 Merge Replication Optimization Tips (Part 1) Create an index on each of the columns that is used in the filter’s WHERE clause. If you do not use indexes on columns used in filters the SQL Server must perform a table scan, which can results in performance degradation. Set the "Maximize Throughput for Network Applications" option. This can…