Troubleshooting
Problem
IBM Db2 Data Management Console (DMC) does not recommend indexes for an SQL statement using the Query Tuning feature, compared to Db2 Design Advisor (db2advis) which returns index recommendations with the same SQL statement
Symptom
DMC does not recommend indexes using the Query Tuning feature for an SQL statement while index recommendations are generated for the same SQL statement using Db2 Design Advisor (db2advis).
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSFQ7S","label":"IBM Db2 Data Management Console"},"ARM Category":[{"code":"a8m50000000Kz6kAAC","label":"DMC-\u003ERun SQL and Tuning"}],"ARM Case Number":"TS014752641","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.1.10;3.1.11;3.1.12"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
More support for:
IBM Db2 Data Management Console
Component:
DMC->Run SQL and Tuning
Software version:
3.1.10, 3.1.11, 3.1.12
Document number:
7173489
Modified date:
01 May 2025
UID
ibm17173489
Manage My Notification Subscriptions