When looking to tune a slow running query on Db2 Warehouse on Cloud, IBM Integrated Analytics System or any other MPP instance of Db2, almost the most important thing to look at first is if the tables are co-located and have good distribution keys.
Oddly, Visual Explain does not show the Distribution key of tables in an explain plan, nor does it expose the distribution of data a a given operator in the plan.
It would be very valuable if this information was surfaced in a prominent position in visual explains in Data Server Manager
Why is it useful?
|Who would benefit from this IDEA?|
How should it work?
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "firstname.lastname@example.org" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions