CHAPTER 9Table Joins and Other Advanced Tuning (Advanced DBA and Developer)
This chapter was the most painful to write because the complexities of Oracle joins and block level tuning come to light here. The driving table or the first table accessed in a query is an important aspect of superior performance. Using the Tuning Pack and the Automatic Workload Repository (AWR) statistics, Oracle can do a lot to help you tune things (see Chapter 5 for more information). If the optimizer has designated the wrong table as the driving table in a query, this choice can make the difference between hours and seconds. Usually, the cost-based optimizer chooses the correct table, but your indexing on tables affects how this works. If you need to change the driving ...
Get Oracle Database 10g Performance Tuning Tips & Techniques now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
