Which tool can be used to get database design recommendations based on SQL statements stored in the database package cache?

One thought on “Which tool can be used to get database design recommendations based on SQL statements stored in the database package cache?”

1. D. The Design Advisor is a tool that identifies indexes, MQTs, MDCs, and
   the repartitioning opportunities for tables, to improve query performance in the database
   environment. it is therefore the tool to be used to get the database design recommendations

   Reply