I am using Oracle as my target table using LiveAuidt option . My understanding is having an index is double load on CDC because it has to do the insert and maintain the index also.
However, the below statement from documentation is contrary to that .Any help appreciated. Practically we do not have requirement for index for access purpose as its a staging area and not an access layer but if adding index helps performance then why not?
Indexes in your target database
A large number of indexes in your target database will put more demands on your target database and take more time to manage when an operation is applied. Tables that do not have a unique index and fragmentation of the table or index will slow down the apply process for the InfoSphere® CDC target replication engine.
You can use the Target Apply metrics in the Management Console Performance view to determine if InfoSphere CDC is extremely slow in applying database operations to your target database. If this is the case, you should determine if a different indexing strategy for the table in question will still meet your querying needs for that table.