IBM
C2090-461 · Question #17
C2090-461 Question #17: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-461 to reveal the answer and full explanation for question #17. The question stem and answer options stay visible for context.
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.
Unlock C2090-461 to see the answer
You've previewed enough free C2090-461 questions. Unlock C2090-461 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.