refresh_loader_drop_index
This system parameter indicates whether or not CDC Replication will drop all indexes on the tables being refreshed and then rebuild the indexes after the refresh. In some environments, this may improve refresh performance.
If the refresh fails for any reason, CDC Replication will write SQL statements to a file which will allow you to manually rebuild the indexes for all tables in your database. The location of the file is specified in the Management Console event log.
- Applies to
- Target datastores
- Values
- Set this parameter to one of the following values:
- Default Setting
- true