DB2 SQL: Rewriting a Distinct with a Correlated Sub-Query to a Group By for Performance Improvement

(Ember Crooks) Sometimes a client calls for help with a performance problem. On one particular Tuesday, a client called about a long-running query. Actually they basically said “What’s wrong with DB2? my query is running long! Are there lock timeouts happening?”

Read More - Register for Free Membership