In this chapter, you will learn
How to tune your database
How to analyze and improve SQL access plans
Performance tuning tips for each of the platforms (LUW, iSeries, zSeries)
How to use the Design Advisor on LUW to create efficient indexes
This chapter is divided into three sections, one for each of the platforms.
This section discusses how to obtain the best performance of your database system with relative ease. When available, the focus is placed on the GUI tools of the various platforms; otherwise, commands will be discussed.
After you have created stored procedures, triggers, and UDFs, it is a good idea to perform an overall tuning of the database system to ...