PrepAway - Latest Free Exam Questions & Answers

What is the primary purpose of the Optim Relationship Index Analyzer Dialog?

What is the primary purpose of the Optim Relationship Index Analyzer Dialog?

PrepAway - Latest Free Exam Questions & Answers

A.
It automatically creates indexes regardless of the user’s rights on the tables involved in relationships used in all access definitions stored in anOptim Repository.

B.
It reviews the last time the RDBMS statistics were updated for tables used in an access definition and automatically issues the commands to update them if they have not been run since the last archive.

C.
It analyzes the index b-trees and if they are inefficient, will drop and rebuild the index automatically or can be scheduled.

D.
It analyzes DBMS indexes for relationships used with the Access Definition and to create any needed indexes, if the user has the correct privileges in the database.


Leave a Reply