9 Chapter 9. Tips to prevent further database performance problems It is important to analyze database performance problems and to fix them. For programmers, it is much more important to know how to prevent those problems from the beginning and how to achieve the best performance. In this chapter, we help you to understand how the optimizer decides for the optimal index, so