Complex SQL tuning in Db2 for z/OS

So many words have been said about SQL tuning. But I would not like to repeat basic questions like how to find appropriate index or how to denormalize your data to make an SQL more efficient. That’s a part of the CV96 IBM Class that everybody has to have in his luggage already. I’d like to take one step further trying to concentrate on complicated SQLs that bothers us and unfortunately appear on our environments from time to time.

Click here to read the full article. (IDUG login required).

 

1 Like
Recent Stories
July Spotlight – Db2 LUW: Types of I/O

Db2 Location Statistics Traces for Remote Applications

Machine Learning with IBM Db2: Building and Deploying a Linear Regression Model