IBM
C2070-987 · Question #8
An IBM Content Manager system administrator found that some query operations had started performing slower. They ran the RUMSTATS and REBlND utilities on the databases to improve query performance…
The correct answer is C. It helps to bind stored procedures to CPUs. See the full explanation below for the reasoning.
Question
An IBM Content Manager system administrator found that some query operations had started performing slower. They ran the RUMSTATS and REBlND utilities on the databases to improve query performance. What impact does periodically running RUNSTATS and REBlND utilities have on the Library Server and Resource Manager databases?
Options
- AIt helps to remove disk fragmentation
- BIt helps to generate good query plans,
- CIt helps to bind stored procedures to CPUs.
- DIt helps to generate disk utilization information.
How the community answered
(29 responses)- A10% (3)
- B3% (1)
- C83% (24)
- D3% (1)
Community Discussion
No community discussion yet for this question.