Oracle7 Server Tuning

Contents Index Home Previous Next

Tuning While Designing and Developing a System

Well designed systems can prevent performance problems later in the life of an application. System designers and application developers must understand Oracle's query processing mechanism to write effective SQL statements. Chapter 2, "Effective Application Design", discusses various configurations for your system and which applications are best suited for each configuration. Chapter 5, "The Optimizer", discusses Oracle's query optimizer and how to write statements that achieve the fastest results.

When designing your system, use the following guidelines for optimal performance:

Chapter 2 and Chapter 5 discuss database design issues more completely. Refer to those chapters before building your applications.


Contents Index Home Previous Next