IBM
C2090-552 · Question #86
What is the primary purpose of the Optim Relationship Index Analyzer Dialog?
The correct answer is D. It analyzes DBMS indexes for relationships used with the Access Definition and to. See the full explanation below for the reasoning.
Question
What is the primary purpose of the Optim Relationship Index Analyzer Dialog?
Options
- AIt automatically creates indexes regardless of the user's rights on the tables involved in
- BIt reviews the last time the RDBMS statistics were updated for tables used in an access
- CIt analyzes the index b-trees and if they are inefficient, will drop and rebuild the index
- DIt analyzes DBMS indexes for relationships used with the Access Definition and to
How the community answered
(36 responses)- A6% (2)
- B3% (1)
- C11% (4)
- D81% (29)
Community Discussion
No community discussion yet for this question.