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).