We have heard from DB2 LUW users that their ETLs take too long. Index changes were the solution.
We have heard that response times were too slow. Index changes were the solution.
We have heard that CPU utilization is too high, or that there are periodic spikes in CPU utilization. Index changes were the solution.
We have seen OLTP applications appear to "seize up" or "stall". Index changes were the solution.
We have seen DB2 users struggle to complete year end and quarter end reports on a timely basis. Again, Index changes were the solution...
[
more .. ]