Which of the following tools can make recommendations for indexes and/or
MQTs to improve the performance of DB2 applications?
A.
Design Advisor
B.
Visual Explain
C.
Performance Advisor
D.
Configuration Assistant
Get 50% Discount on All Your Purchases
at PrepAway.com - Latest Exam Questions
This is ONE TIME OFFER
50%
The DB2 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