You discovered a slow performance issue during an archive process with delete deferred. By using the Statistical Report and the Relationship Index Analysis, you were able to determine that there was a missing index on one of the tables. The index has been added to the database, and the Statistical Report reflects that the index is being used for a key lookup. Performance has improved somewhat. Which two actions will help you to further increase performance of the archive? (Choose two.)

You discovered a slow performance issue during an archive process with delete deferred. By using the Statistical Report and the Relationship Index Analysis, you were able to determine that there was a missing index on one of the tables. The index has been added to the database, and the Statistical Report reflects that the index is being used for a key lookup. Performance has improved somewhat. Which two actions will help you to further increase performance of the archive? (Choose two.)
A . Force a scan on this table.
B . Increase your commit frequency.
C . Use more than one database connection for the archive process.
D . Increase the Key Lookup Limit for this table.
E . Turn the Compare Rows option off.

View Answer

Answer: C,D