What is the purpose of the Design Advisor?
A.
To analyze workloads and make recommendations for indexes and MQTs
B.
To present a graphical representation of a data access plan and recommend design changes
that will improve performance
C.
To replicate data between a DB2 database and another relational database
D.
To configure clients so they can access databases stored on remote servers
Design Advisor advises users on the creation of materialized query tables (MQTs) and indexes
0
0
The Design Advisor takes as input a workload that is either provided in a file,
captured in the cache, in a DB2 Query Patroller repository, and more. Using the
workload, the Design Advisor can suggest a change to the underlying database
schema to attain optimal performance based on the submitted workload. The Design
Advisor can suggest new (or changes to) indexes, MQTs, MDCs, and partitioning
keys (used when you’ve installed the Database Partitioning Feature). It can also
identify indexes that aren’t being used for possible removal.
0
0