IBM
C2090-552 · Question #40
C2090-552 Question #40: Real Exam Question with Answer & Explanation
The correct answer is C. Use more than one database connection for the archive process. D. Increase the Key Lookup Limit for this table.. See the full explanation below for the reasoning.
Question
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.)
Options
- AForce a scan on this table.
- BIncrease your commit frequency.
- CUse more than one database connection for the archive process.
- DIncrease the Key Lookup Limit for this table.
- ETurn the Compare Rows option off.
Community Discussion
No community discussion yet for this question.