CHAPTER 11Beyond Data Access and Join Optimization

The optimization of data accesses and joins must be performed before considering the advanced optimization techniques presented in this chapter. In fact, the optimization techniques described here are intended only to further improve performance when it is not possible to achieve it otherwise. In other words, you should fix the basics first, and then, if the performance is still not acceptable, you can consider special means.

This chapter describes how materialized views, result caches, parallel processing, direct-path inserts, row prefetching, and the array interface work and how they can be used to improve performance. Each section that describes an optimization technique is organized in the ...

Get Troubleshooting Oracle Performance now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.