SQL Tuning Techniques

Whenever the query optimizer is unable to automatically generate an efficient execution plan, some manual tuning is required. For that purpose, Oracle provides several techniques. Table 7–1 summarizes them. The goal of this chapter is not only to describe these techniques in detail but also to expla... View More