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
Anomaly Detection in Python and SQL (part 2)

Db2 Client Packages

INDEX COMPRESSION in Db2 Z, A recap and overview!